YTD Reports

[SarahJ]

I have a report that pulls YTD reports. Since we are now going into a new
year I would like it to only report 2008 data what do I need to put in the
query to make it only pull the current year data?

 

[John Spencer]

Assuming you have a date field to base this on

Field: SomeDate
Criteria: > DateSerial(Year(Date()),1,1)

That criteria gets all records on or after midnight of January 1 of the
current year (as determined by your computer's system date).

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Duane Hookom]

Your Where clause would contain something like:
WHERE Year([YourDateField]) = Year(Date())

 

[SarahJ]

Got it thanks so much for your help... You guys are great!

 

[SarahJ]

Your Where clause would contain something like:
WHERE Year([YourDateField]) = Year(Date())

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

I have a report that pulls YTD reports. Since we are now going into a new
year I would like it to only report 2008 data what do I need to put in the
query to make it only pull the current year data?