Performing mathematical calculations in access 2003

[kie]

Hi

I am setting up a database and I need some help performing maths in a report. Basically, I have a report based on query. I have the query working and it is multiplying a QTY by a price andf this is fine. This data is not stored in any tables, it is just there to be displayed and to come out on a printed version of the report.

Then at the bottom of the report, I want to add up all of these totals. I have a text box and the control source is something like this - =Sum([total])

total is worked out using this formula in design view of the query

total: CCur([codes&prices].MSHRate*[QTY])

Where the text box is in the report, it just say #Error

Any help would be appreciated.

Many thanks

 

[jjsevdt]

In your formula: total: CCur([codes&prices].MSHRate*[QTY])

What is the query(s) that the information is coming from let me know. It looks like the part I made red is specifying a field from a query and they should be seperated as such -> [name]![name] That's one thing I noticed I wanted to know the layout of your DB so I can help you out better. I work in Access alot, so i'll try.

 

[kie]

Hey

Both bits of data are coming from a table

total1: CCur([codes&prices].MSHRate*[Qty])

codes&prices is a table and that is where MSHRate comes from. QTY comes from a table called TestTable.

Thanks for the help

 

[jjsevdt]

CCur([codes&prices]![MSHRate]*[Qty]) Try it like this if not let me know.

 

[kie]

i'm still getting #error

 

[kie]

I wanted to know the layout of your DB so I can help you out better.

Maybe this will help