Sum of a Field (Access)

[JoDaMa]

Hi,

Sorry if this is in the wrong forum section, couldnt find anywhere better.

Im having a little trouble with access 2003, it doesnt recognise my queries for some reason.

Im trying to calculate the sum of all the values in a particular field (currency data type).

This is the expression im using:

Expr1: Sum([Printer Specification Table]![cost_of_printer])

Access refuses to run it and says 'cost_of_printer' is not part of an aggregate function.

Can anyone give me an idea of how to do this, ive tried googling it and nothing is helpful. Im kind of new to access so be nice

Thanks

 

[RockLobster]

Have you added Group By to your query?

 

[JoDaMa]

I have used the totals button to show the total row in the query design view. Each of the 3 fields i want in the query is showing 'Group by' underneath it, what i want is to show every record from each of the 3 fields, then show the sum of each field below the individual records. And then after that i want to find the total by adding the totals of the 3 fields.

Hope you understand me

By using the group by, it still shows the individual records in the report right? and if i change the 'group by' to 'sum' then it will total up each record in that field correct?

Thanks