How to total quantities of multiple like records in a report?

[Guest]

I do not have official training in Access. I have learned it on my own.
I have a table with like items listed because of a shipment number,
currently at 310.
I am recording the usage, but because there are several records for these
like items there is a need to get a final total of the remaining quantity.
I have several reports and queries, but not the information I am looking for.
I am using Access 2003.

 

[John Vinson]

I do not have official training in Access. I have learned it on my own.
I have a table with like items listed because of a shipment number,
currently at 310.
I am recording the usage, but because there are several records for these
like items there is a need to get a final total of the remaining quantity.
I have several reports and queries, but not the information I am looking for.
I am using Access 2003.

A Totals query based on your table should be able to do this. Create a
new Query based on the table; add the field upon which you wish to
group and the field that you wish to total, and click the Greek Sigma
icon (looks like a sideways M). Set the "Total" row to Group By or Sum
as appropriate.

Note that totals should NOT be stored in any table.

I hope this helps - it's unclear from your post just how your table is
structured or even what information you actually *are* looking for, so
I'm guessing a bit!

John W. Vinson[MVP]