YTD Calculations

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

Guest

Are there any tricks to calculating YTD and Last Year Numbers

I have a Field [Total Sales] and a separate field [Order Date]

I can figure out how to calculate for this year only and for last year only
 
Stephen said:
Are there any tricks to calculating YTD and Last Year Numbers

I have a Field [Total Sales] and a separate field [Order Date]

I can figure out how to calculate for this year only and for last
year only
Click to expand...

You don't give much information to go on, but you might try a query
along these lines to get total sales for this year:

SELECT Sum([Total Sales])
FROM YourTable
WHERE [Order Date] >= DateSerial(Year(Date()), 1, 1)
AND [Order Date] < DateSerial(Year(Date()) + 1, 1, 1);

And similarly for last year:

SELECT Sum([Total Sales])
FROM YourTable
WHERE [Order Date] >= DateSerial(Year(Date()) - 1, 1, 1)
AND [Order Date] < DateSerial(Year(Date()), 1, 1);
 
Back
Top