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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Year Beginning Date 2
Totals for month and year 4
Excel Vba to change displayed year automatically. 14
Limiting YTD totals to date 4
Expression used to calculate previous ytd count 4
Calculating YTD totals on a Fiscal Year 7
Calculate MTD and YTD in a query 8
Year to date values 2

Back
Top