adding parameters to count query

[Weresmytriple]

hi,

i have set up a query to count the different ethnicitys of people who have submitted a complaint. it works fine when I leave it just doing that.

However when i add a field to allow me to add the parameters for a search between to dates. the query will only count the ethnicity of people who complained on the same day and give the others as a single number.

i need to allow the user to search between dates as to generate the data for a report.

thanks for any help

michael

 

[pr2-eugin]

Change the GROUP BY of the Date field "Date Of Complaint" to WHERE from the Drop Down List.

 

[Weresmytriple]

thanks i cant believe it was that simple

 

[pr2-eugin]

You're welcome.

i cant believe it was that simple

Not always.

Glad you have it sorted though. Good Luck.