Group By query

[joeblow3]

I am doing a "group-by" query. There is one field - a date field - which I want to appear in my query because it's tied to parameter conditions.

But I don't want it as a group-by field because it gives me duplicate records. However, I get an error message if I don't put group-by in the total box for the date. How do I go about it?

Thanks in advance.

 

[dhookom]

You have a query question, you should provide your SQL view.
You might be able to simply change the GROUP BY to WHERE. Uncheck the View checkbox.

Duane
Hook'D on Access
MS Access MVP

 

[joeblow3]

Thanks dhookom.