Calculation in report

  • Thread starter Thread starter SJL
  • Start date Start date
S

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?
 
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
 
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?
 
Hi Deepak. Thanks so much.

Stu

Deepak said:
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


SJL said:
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?
Click to expand...
Click to expand...
 
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
 
Back
Top