Query: Group by, Sum

[dkubiak]

I can't figure this one out. I built a query to calculate my "on hand quantity" for an inventory database. I have three columns: 'QPartNumber', 'Issue', and 'Received.' I simply want it to group by 'QPartNumber' and give me the sum of 'Issue' and the sum of 'Received.'

When I tested it, I get back double the actual amount in those columns. I even deleted every record, entered one with the value of '4' in 'Issue'. The query gave me the sum of 8!!!

Please help!

 

[cstlaurent]

Can you post the query that you have.

I connot see why it is doing so.. Do you have other criteria like a date or something that you are using..

 

[dkubiak]

Well, I rebuilt the query using the wizard and it works. I compared my query and the wizard-query and could find no differences. So, to ease my frustration I deleted the one that didn't work.

If I have a chance I will rebuild it later and post it here for all to ponder.