Calculating Year To Date Totals

[Guest_imported]

Hey,

I know that there is an easy way to do this but I am having a brain cramp with this. I am trying to add up the Extended price of products that were order on or after Jan. 1, 2001. I can't seemt o get the expression down and it is driving me crazy if anyone can help I appreciate it.

 

[Databaseguy]

If it's a query, type this in your criteria:

Between #01/01/2001# and Now()

This is "Hard coded". That is, next year you'll have to change it.

A flexible version would be:

Between (CDate("01/01/" & Right(Date(),4))) And Now() Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy