Access Reports

[Dongola]

I’ve created a report in Access, the source of the report is an access query. It displays as follows

Item Name Price
A 700
B 65
C 50


Etc
In the report I want to add another column called Difference
Item Name Price Difference
A 700 50
B 650 150
C 500
Can this be done using calculations?

[hertfordkc]

Your example is confusing. However the answer to the question is "Yes, the difference can be calculated." The post doesn't give enough info to determine if the calculation should be done in the query on which the report is based, or on the report itself.

[Dongola]

Your example is confusing. However the answer to the question is "Yes, the difference can be calculated." The post doesn't give enough info to determine if the calculation should be done in the query on which the report is based, or on the report itself.

Thanks hertfordkc;94152
Either in the Report or the Query is fine, but how do I do it?

[hertfordkc]

With your Table (tblOne), assume that you have fields Item, Name, Price and Cost.
Go to query design, and open a blank query. Insert tblOne. Insert the fields into the query columns.
To calculate the difference, go to a column without a field name and insert:
Diff:[Price]-[Cost]

Run the query.
The inserted formula can be very complex.
For other explanations, Google 'access query calculated fields'.