C Cdogg Registered User. Local time Today, 23:50 Joined May 20, 2001 Messages 30 Jan 1, 2002 #1 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
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
R raskew AWF VIP Local time Today, 17:50 Joined Jun 2, 2001 Messages 2,734 Jan 1, 2002 #2 In your query, add a field for the year, e.g. Year([OrderDate]) and set its criteria as Year(date())
C Cdogg Registered User. Local time Today, 23:50 Joined May 20, 2001 Messages 30 Jan 1, 2002 #3 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())
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())
R raskew AWF VIP Local time Today, 17:50 Joined Jun 2, 2001 Messages 2,734 Jan 1, 2002 #4 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.
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.
