Designing a "totals" query in the design grid produces:
SELECT [Harms and Steven ].inspectionID, Count([Harms and
Steven ].inspectionID) AS CountOfinspectionID FROM [Harms and Steven ]
WHERE ((([Harms and Steven ].[inspection date]) Between #1/1/2004# And
#12/31/2004#))
GROUP BY [Harms and Steven]. inspectionID
- where "inspectionID" = the unique inspection record key field
-Ed
<ra*********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Greetings ... I have a table named Harms and Steven with a field named
inspector (text) and inspection date (date/time).
I need to count up how many times the inspector appears for any
inspections occured in 2004.
Here's what I have, but it's giving me problems ... what am I doing
wrong?
Thanks.
WHERE (DateSerial(Year([inspection date]),)=#2004#))