Calculating YTD

E

ExecutiveBest

I am trying to use a query to calculate YTD totals. My access database
tracks lease fees paid. I already have a field that calculates total fees
paid. I used a query for that. I need this same query to calculate fees
paid from January 1, 2005 to now. Not just from September 1, 2004 until now.
Can anyone help me. Please give me a formula or aggregated
statement/function; i could use the sql statement but you will have to "keep
it simple stupid" for me to understand it.
 
D

Douglas J. Steele

What's the SQL your using for your total fees paid? That will help us use
the same field names as you have...

Basically, you need to add a WHERE clause that limits the query to those
records that are after Jan. 1.
 
V

Van T. Dinh

Perhaps, it is as simple as slight modification of the criteria of the
query you are using for total fees paid from Sept 01, 2004.

If you need help with this modification, post the SQL of the current query.
 
Top