Calculation in report

[SJL]

Hi, I have a table that has an estimated cost (Est £'s) and actual cost (
Actual Expense) fields. How do I get the report to calculate the difference
please?

 

[Deepak]

Make a select query based on table.
add both the fields to query
and in third column write Diff: estimated cost - actual cost
save the query and make report using wizard and select this query name
Hope this helps

 

[SJL]

Hi Deepak

Thanks, but I get an error message " Expression contains invalid syntax. The
fields are actualy called Cost £'s and Actual Expense. I type in Diff:Actual
Expense-Cost £'s and get that message above. Can you tell what I am doing
wrong please?

 

[SJL]

Hi Deepak. Thanks so much.

Stu

ok
You can do this
Diff: [tablename]![Actual Expense] - [tablename]![Cost £'s]
since ur field name contain spaces.
for this to work......both fields should be in same table
or both the tables should be linked

Hi Deepak

Thanks, but I get an error message " Expression contains invalid syntax. The
fields are actualy called Cost £'s and Actual Expense. I type in Diff:Actual
Expense-Cost £'s and get that message above. Can you tell what I am doing
wrong please?

 

[Deepak]

ok
You can do this
Diff: [tablename]![Actual Expense] - [tablename]![Cost £'s]
since ur field name contain spaces.
for this to work......both fields should be in same table
or both the tables should be linked