Adding calclations to a report

[Access08]

Hi I need some help to do some calculations on a reports, as I will using it for invoicing.

Can someone tell me how I can have data from two different sheets calculated and then appear on my report.

 

[Rabbie]

Hi I need some help to do some calculations on a reports, as I will using it for invoicing.

Can someone tell me how I can have data from two different sheets calculated and then appear on my report.

Can you clarify what you mean by sheets. Are you referring to Tables , Queries or What??

 

[Access08]

sorry should have given more detail.

I would like to cross calculate two or more tables, then take the results and present it in the form of a report.

i will need to do this every month, so I’m trying to find the best way as well as the quickest way to do this.

 

[Rabbie]

Build a query to get the data from the tables including calculated fields which shouldn't be in the tables anyway.

Build your report from the Query.

 

[Access08]

thank you, i will give this a try and let you know how i get on.