Limiting query return

  • Thread starter Thread starter papa jonah
  • Start date Start date
P

papa jonah

I am not sure what to call it, so I have not had much luck in searching
for the answer.
What I need to do is analogous to doing a search of all customers who
placed orders from January 1 to March 31 - but only wanting each
customer to show up in the resultant report once regardless of how many
times they placed orders.

If I am running my query with criteria assigned to date, how can I
limit the number of times a customer appears?

TIA, Papa
 
"group by" and "where"?
I don't understand. I am using the query design feature and see field,
table, sort, show, criteria, and or. I guess this isn't what you are talking
about. Sorry for being such a novice.

Papa
 
In your tool bar goto view, Groupby.
Now you get another row in your query that show group by for all the fields.
in the date field change the gruop by to where.
 
Back
Top