Hi guys,
I have a problem and i'm sure that you guys can help me to solve it.

My problem and my question is that how can you get calculated column in sql queries.
like

tffam110.cost(1) - tffam110.ltdd(1)

example

select
tffam110.anbr, | Asset Number
tffam110.cost(1) - tffam110.ltdd(1)
from
tffam100, | Asset
tffam110 | Asset Book
where
tffam100.aext >= tffam100.aext.f and
tffam100.aext <= tffam100.aext.t and
tffam100.anbr >= tffam100.anbr.f and

You could include tffam110.cost(1) and tffam110.ltdd(1) in your SQL select statement and then edit the report layout that gets generated by the query and add a new form field for tffam110.cost(1) - tffam110.ltdd(1).

Mike