Entering parameters to a count query

[Weresmytriple]

Hi I'm working in access 2003.

I am running a count query on the ethnicity field from the patient table. This part is working fine.

However when I try to add a parameter to search between two dates it stops the count functioned working properly. I am trying to add the parameter from the complaint table. An the date of complaint field.

I am trying to do this by "between [startdate] and [end date]"

Any help o. How to do this would be much appreciated.

Thanks

Michael

 

[pr2-eugin]

Could you show us the Query you are using?

 

[Weresmytriple]

I can't as I currently have no Internet in my office and I'm on my phone