current vs last year's sales

[humvie]

Any one know of any threads that explains how to establish current year (assuming from computer settings ???) and then establish the year prior, then continue on with the rest on my query to finally arrive at comparing this year from last year?

Much appreciated. (I already tried searching "current, last year, "sales", etc. ... but nothing close to what I need.

 

[WildHare]

Year(SomeDateGuy) returns the year portion of a date.

Year( DATE() ) = 2003

DateSerial(Year(DATE()-1) returns the previous year, no matter when DATE() is

Check out the Year, DateSerial, DateAdd, and DateDIFF functions. They'll do what you want.

Jim


Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm