Total from a Total

[Supertech]

Ok, i'm using access to controll inventory in a very high security envionment. My Supervisor would like a total value of all parts in our possession. When i run a query i can get a total value for individual parts, however i need a total value for all parts combined.

P.S. i'm too lazy to use a calculator but i can guarantee you would be too, we've got over a thousand parts in 6 different tables.

Thanks for any help,
Supertech

 

[Supertech]

I'll give that a try, Thanks