Curret Year

[rickyzicky]

I have a simple query that returns 2 fields"
DateEntered
Amount

I am trying to build a query where it returns just the current years records.
I have tried Where Year(Date()) as the criteria, but it doesn't list all the records for the year and instead returns 1 record with the current date in it and a blank record in the Amount. There are anounts in all fields.

Any suggestion, so in 1/1/2004 the query will filter 2003.

Thanks

 

[rickyzicky]

Got it:
Year([Fieldname])=Year(Now())