I have a unique issue with a query that simply groups inventory in multiple locations by their department prefix (VS, QC and so forth) and lot number then sums the on-hand quantities. My problem is there always seems to be on entry that will have a doubled value. This is consistent until the item is consumed and then I may go a week or two before another number picks up this attribute. To work around this I have another query that does that same thing but only works with the single inventory table (the problem child has multiple tables all linked one to one with a master list.
Sum value get doubled sometimes
- Thread starter L8asusul
- Start date
A query can select double records or even more sometimes depending on the join.
If you do not notice this and then run a Sum, you will get error results.
Run the same query as just select, not Totals. and confirm the corect number of records are returned. Should be the same number as your Inventory Items.
Another issue could be if your final query has one or more queries included in the data source.
Maybe one of these earlier queries is duplicating a record.
Something must be wrong with a query or even a table (not sure how that can be) but you can be assured, you have not discovered an error in Microsoft's programme. I thought I did a few times
but it always ended up with some issue in my work.
If you do not notice this and then run a Sum, you will get error results.
Run the same query as just select, not Totals. and confirm the corect number of records are returned. Should be the same number as your Inventory Items.
Another issue could be if your final query has one or more queries included in the data source.
Maybe one of these earlier queries is duplicating a record.
Something must be wrong with a query or even a table (not sure how that can be) but you can be assured, you have not discovered an error in Microsoft's programme. I thought I did a few times
but it always ended up with some issue in my work.