Count Records between two dates

[MJCRN]

Hi,
I am trying to count the number of records (intake files in this case), that occurred between two dates. I have successfully created a query that provides the full list of these records (seen below), but I would like a count instead of the list. I keep getting errors when I try to use count functions.

Table: Client_Intake
Records to count: Date_of_Intake

SELECT Client_Intake.Date_of_Intake, Client_Intake.First_Name, Client_Intake.Last_Name
FROM Client_Intake
WHERE (((Client_Intake.Date_of_Intake)>=[forms]![AdministrativeForm]![StartDatebox] And (Client_Intake.Date_of_Intake)<[forms]![AdministrativeForm]![EndDatebox]));

Thanks in advance for any help!


M

[rpeare]

Try

SELECT Count(Date_of_Intake) as TotalIntakes 
FROM
(SELECT Client_Intake.Date_of_Intake, Client_Intake.First_Name, Client_Intake.Last_Name
FROM Client_Intake
WHERE (((Client_Intake.Date_of_Intake)>=[forms]![AdministrativeForm]![StartDatebox] And (Client_Intake.Date_of_Intake)<[forms]![AdministrativeForm]![EndDatebox])))

[orange]

Cross posted at http://www.utteraccess.com/forum/ind...ic=2036883&hl=

MJCRN, please see this re cross posting