Year to Date

How could I put restrictions in Criteria for the current
year to date in the one field and for the previous year to
date in the second field to compare the data?

Thanks

On Tue, 20 Jul 2004 13:00:29 -0700, "Alex"
wrote:

How could I put restrictions in Criteria for the current
year to date in the one field and for the previous year to
date in the second field to compare the data?

Thanks

Add the table to the query grid TWICE; join by whatever key field
identifies what it is that you want to compare over years. Then in one
instance put

= DateSerial(Year(Date()), 1, 1) AND = Date()

as a criterion on the date field; in the second instance use

= DateSerial(Year(Date()) - 1, 1, 1) AND = DateSerial(Year(Date()) - 1, Month(Date()), Day(Date()))



John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Could you type in about 10-12 records as well as your expected display? It
would save us from making WAGs regarding what you have and what you want.

--
Duane Hookom
MS Access MVP


"Alex" wrote in message
...
How could I put restrictions in Criteria for the current
year to date in the one field and for the previous year to
date in the second field to compare the data?

Thanks

Thanks a lot, John.
These are the formulas I needed.
How could I interpret it if my fidcal year is Aug 1 to Jul
31?

Thanks

-----Original Message-----
On Tue, 20 Jul 2004 13:00:29 -0700, "Alex"
wrote:

How could I put restrictions in Criteria for the current
year to date in the one field and for the previous year
to
date in the second field to compare the data?

Thanks

Add the table to the query grid TWICE; join by whatever
key field
identifies what it is that you want to compare over
years. Then in one
instance put

= DateSerial(Year(Date()), 1, 1) AND = Date()

as a criterion on the date field; in the second instance
use

= DateSerial(Year(Date()) - 1, 1, 1) AND = DateSerial
(Year(Date()) - 1, Month(Date()), Day(Date()))



John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
.