DCOUNT GIVES ALL

[Angelique]

DCount working fine except it is giving me all the occurrences in the table and I need the report to display only those between a start date and finish date.

Unbound textbox control source:
=DCount("[Status]", "Training Details", "[Status] ='Cancelled'&quot

Report record source: qryTrainingDetails
SELECT * FROM [Training Details] where ((([Training Details].[Date of Training]BETWEEN [Enter Start Date] and [Enter End Date])));

Any ideas? Joe you seem to get me closer each time!


Angelique

 

[Aivars]

=DCount("[Status]", "Training Details", "[Status] ='Cancelled' And ([Date of Training] BETWEEN #" & [Enter Start Date] & "# And #" & [Enter End Date] & "#)&quot

Aivars

 

[Angelique]

Thanks for the help.

No syntax error but get #Error with this! any ideas why?


Angelique