View Full Version : Current Year


Cdogg
01-01-2002, 04:10 AM
I would like to have a querry look up the records for the current year with having to inter the year

Thank you for your help

raskew
01-01-2002, 04:20 AM
In your query, add a field for the year, e.g.
Year([OrderDate]) and set its criteria as Year(date())

Cdogg
01-01-2002, 04:49 AM
Thank you for helping (Happy New Year)
Is this the way I’m to enter it .

In the field: Year:Year([Date])
By group
Criteria: Year(Date())

raskew
01-01-2002, 05:51 AM
Yeah, you've got the idea. Only thing I'd suggest changing is to call the calculated field something other than Year, e.g. MyYear, since Year is also the name of a function.