Date Range with Total Count Query

[Guest]

I want a query that ask the date range and give you a total count. This is
what I've got:
FieldroficiencyCompletionDate
Table:CompletionQuery
Total:Count
Show: (checked box)
Criteria:Between[EnterStartDate]And[EnterEndDate]

it's not working I get the following error message:
This expression is typed incorrectly, or its too complex to be evaluated.

please help
Kim

 

[John Spencer]

The error occurs because you are trying to find a COUNT that has a value
between two dates. What you want is a count of records where the date is
between two dates.

FieldroficiencyCompletionDate
Table:CompletionQuery
Total:Count
Show: (checked box)
Criteria: Leave this blank

Add the ProficiencyCompletionDate to the query a second time and it as
follows

FieldroficiencyCompletionDate
Table:CompletionQuery
Total: WHERE
Show: NOT checked
Criteria:Between[EnterStartDate]And[EnterEndDate]

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Try

Select Count(*) As CountOfRecords
From CompletionQuery
Where ProficiencyCompletionDate Between [EnterStartDate] And [EnterEndDate]