MajP
You've got your good things, and you've got mine.
- Local time
- Yesterday, 22:21
- Joined
- May 21, 2018
- Messages
- 8,992
If interested, I will look at this, but I would think you could make this editable. This is not super efficient but the list is never going to be super long so should not be a problem. You need to remove the aggregate query and use a function instead. This is the same approach people do when they want to show "row numbers" per record. The function will pass an item and productid and return the Product name if it is the first record (sorted by Item) or null if not.I am leaving it the way I have it which IS editable, and the sections are highlighted, the only thing is I have the product name on each line which is fine...
FYI, the field name "Count" is on the naughty list and is confusing to me because it can mean so many possible things. Normally I would expect the word to by "quantity"
Learn about Access reserved words and symbols - Microsoft Support
support.microsoft.com