Adding a Single Column to get amount

[cpeterson]

I made a query for signle item I want to add number of items, in that field.
For example. I have several records for a field that have a number value like 10, 10, 10, 10 and want to add these up to get a total in this field,

Item Quantity
Quickset 10
Quickset 10
Quickset 10


I'm using in my field as the following

=Nz(Sum([Quantity]),0)

when executing the command I'm getting the following

Item Quantity
Quick Set 10
Quick Set 20

for the fields, I'm wanting to use this for report purposes. I'm not sure how to get the total to work for me.

Hope this is understand able. I know there is a simple solution, but just can't think of what it would be.

 

[NewShoes]

Are you using the query builder in Access? If so, you can simply click the Totals button and then select SUM on the field you wish to sum up.

 

[cpeterson]

Getting the same results in Query Builder..

 

[cpeterson]

I think i found out what the issue was. My table for the one I was trying to inquire on was corrupted. Did it on a different table and works. I was on the right track, with corrupted data.