YTD Calculations

[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

 

[Dirk Goldgar]

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

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);