Year to Date

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

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
 
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
Click to expand...

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()
Click to expand...

as a criterion on the date field; in the second instance use
 
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.
 
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-----


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


as a criterion on the date field; in the second instance use
Click to expand...
(Year(Date()) - 1, Month(Date()), Day(Date()))
 
Back
Top