I need some help better understanding the Group by in a query in MS Access. I want to group my field SKUs.SkuID but I don't need anything else in the totals for the other fields.
I have 4 fields and this includes two tables. Two fields in each table each field showing whether a record is new or modified. So in the criteria for each field I have = True
This is causing access to generate multiples of the same record. In SKUs there is 1 record and in Products there may be up to 5 records that match when the link is on SkuID. So the query results will show 5 lines of records and I just need one.
So what do I do to just group by in the SkuID field? I can't leave the other fields Total empty....
FROM Products RIGHT JOIN SKUs ON Products.SkuID = SKUs.SkuID
WHERE (((SKUs.SkuNew)=True)) OR (((SKUs.SkuModified)=True)) OR (((Products.NewItemFlag)=True))
ORDER BY SKUs.SkuID;