dkubiak
Board Regular
- Joined
- May 17, 2004
- Messages
- 137
- Office Version
- 2013
- Platform
- Windows
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!
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!