I have a select query which displays the items ordered for a customer. I use this as the Record Source for the subform.
Some of the items in the order table have the same category. for example 'Dolls" or 'Clothes'
I would like to display in the subform, subtotals for Dolls, Clothes etc.
So, grouping the price for all the Dolls
and another field which groups all the Clothes.
The challenging thing is the category description is dynamic. it could be Dolls, one week, then Dollies the next. So what I am saying is I can't use a fix criteria for the category field as it changes every so often.
P.S Dolls and Clothes are merely examples not actually categories