Adding quantities in a report

[gcomp]

I have a database that stores project information. The key items are "job number", "material type" and "material amount". We have thousands of "material type". Each project may use the same "material type" in several different sections. I would like to be able to sum the "material quantity" for each "material type" for each "job number". I know I could probably do something with IF THEN statements, but like I mentioned, we have thousands of "material type". Any help or ideas would be much appreciated.

 

[Mr. B]

A totals type query should provide you with totals grouped in any way you want.

I would first ask how you are storing you data? The description you provided of the data indicates a many-to-many relationship. Do you have your data structured to handle this situation.

 

[gcomp]

Mr. B - Your wise words gave me the direction to look and I was able to resolve my issue with ease. Thank you for your expertise.

 

[Mr. B]

You are quite welcome. Glad to help.

Good luck with your project.