Limiting query return

[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

 

[Guest]

Put your query in group by, and the date change from group by to where.

 

[Guest]

"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

 

[Guest]

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.