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
Thank you for your help
|
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. |