SaladProblems
Active Member
- Joined
- Apr 9, 2010
- Messages
- 279
Hi! I have a table of binders, and on each binder I have a box number.
There's supposed to be 14 binders in each box, and I'm trying to figure out how to display all boxes which do not contain 14 binders.
I can get a report to display a tally of boxes and do it indirectly, but I don't know of a good way to filter by the count of a field, I've been trying to build a query to do this and I've run into a wall with an aggregate function error message.
Is there a good resource to explain this, or is it something simple that I just don't understand?
There's supposed to be 14 binders in each box, and I'm trying to figure out how to display all boxes which do not contain 14 binders.
I can get a report to display a tally of boxes and do it indirectly, but I don't know of a good way to filter by the count of a field, I've been trying to build a query to do this and I've run into a wall with an aggregate function error message.
Is there a good resource to explain this, or is it something simple that I just don't understand?