YTD Reports

  • Thread starter Thread starter SarahJ
  • Start date Start date
S

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?
 
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
..
 
Your Where clause would contain something like:
WHERE Year([YourDateField]) = Year(Date())
 
Duane Hookom said:
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


SarahJ said:
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?
Click to expand...
Click to expand...
 
Back
Top