DateSerial Query

[ralph_noble]

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(Yea r([inspection date]),)=#2004#))

[pietlinden]

ra*********@hot mail.com wrote:

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(Yea r([inspection date]),)=#2004#))

Huh? DateSerial is for converting something to a date... no idea what
you're doing with it.

How about something like:
WHERE Year(Inspection Date)=2004

[Ed Robichaud]

Designing a "totals" query in the design grid produces:
SELECT [Harms and Steven ].inspectionID, Count([Harms and
Steven ].inspectionID) AS CountOfinspecti onID 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 "inspection ID" = the unique inspection record key field

-Ed

<ra*********@ho tmail.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.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(Yea r([inspection date]),)=#2004#))

[Douglas J. Steele]

The DateSerial function requires 3 arguments: a year, a month and a day.

Try WHERE Year([inspection date]) = 2004

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<ra*********@ho tmail.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.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(Yea r([inspection date]),)=#2004#))