I am trying to get the SUM of a field, which is called PRICE. The entire sum is simple but I would like to get a Month to Date total by only adding the orders taken from the first of the month until today's date from the ORDER DATE field.

In addition, I would like to calculate a year to date, 1999 total, and a 1998 total.

Any assistance is greatly appreciated.

Regards,
Tony

For both cases to a Sum of Price with the ORDER DATE Criteria of a Between ... And ...
placeing the first date (Such as 10/1/1998, or 1/1/1999) and the Second Date (10/31/1998 or 12/31/1999)

Travis,
Thank you for the reply; however, I want the form to do this automatically as it loads.

I have a text box called month to date. When the form loads it will calculate the month to date sales total, regardless of which month it is.

Thanks again,
Tony