Year to Date Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I'm creating that needs to have a year to date total included. Under normaal circustances I would just use the take the system date and include all records between the start of the year and todays date. That won't work for the report I need to created. I need year to date to be the the total of all the previous month totals. For example if the report was run on March 15th it would use the total from January 1st through the end on febuary for ytd caluclations. Ho can I accomplish this.
 
Use criteria on your date field that looks something like this:
=DateSerial(Year(Date()), 1, 1) And <DateSerial(Year(Date()), Month([Your
Click to expand...
Date Field]), 1)

George Schneider said:
I have a report that I'm creating that needs to have a year to date total
Click to expand...
included. Under normaal circustances I would just use the take the system
date and include all records between the start of the year and todays date.
That won't work for the report I need to created. I need year to date to be
the the total of all the previous month totals. For example if the report
was run on March 15th it would use the total from January 1st through the
end on febuary for ytd caluclations. Ho can I accomplish this.
 
Back
Top