Hello and a big thank you to all of you for your help. I want to create a “comparison query” for lack of a better term. I have a query that tells me the numbers of units sold on each day. Now I would like to create a query that will show me what each item has done over a specified period. The period could be preset to a weeks time, a month, a quarter, a year.
I don’t really have a clue as to where to begin.
Bret