Re: records with current year

aubrey wrote:
"Rick Brandt" wrote:
WHERE [DATE CERTIFIED] >= DateSerial(Year(Date())-3,1,1)
AND [DATE CERTIFIED] < DateSerial(Year(Date())-2,1,1)

Don't apply criteria to an expression if you can avoid it.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


sorry for the ignorance, but where should i be entering that
expression

Under the field [DATE CERTIFIED] in the query designer enter in the criteria
row...

= DateSerial(Year(Date())-3,1,1) AND < DateSerial(Year(Date())-2,1,1)


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.

Relevant Pages