DCount Error

[tareyj8569]

Hey heys,


I have a report I am trying to do with multiple DCounts that are on unbound Text Boxes. The DCounts work perfectly ...as long as I dont use date criteria.
Example of DCount code =DCount("[Location]","TestQ","[Location] = 'Pink 1'")
The Report looks at a query that has a date field which in the criteria if I had Between [Enter Start Date] AND [Enter End Date] it prompts the 2 but the fields will display #ERROR but without the between in the query works just fine. If I run query not the report the data pulls. Can someone please direct me in the right direction so user can type the between date and the dcounts will work without Error out. (Thought I was close)

Thanks for your time and help as always!!

[June7]

I never use dynamic parameter input popup in query, actually, never use dynamic parameters at all in query.

I have criteria input into textboxes on form then refer to the textboxes. Either the query can reference the textboxes or the DLookup expression can.

=DCount("[Location]","TestQ","[Location] = 'Pink 1' AND [date field] BETWEEN #" & [Forms]!formname].[tbxStart] & "# AND #" & [Forms]!formname].[tbxEnd] & "#")

[tareyj8569]

Took me a few to set up correctly, but now that it is works like a charm.. thank you so much!