Month To date Calculation

J

John Foster

Is there a way to print a report and only print the current months data to
date.

ie today is 1/6/06 and I would like to show only those values for
1/1/06-1/6/06 but tomorrow I would like for it to go to 1/7/06 and then next
month start all over again.

Any help would be greatly appreciated.

John
 
J

John Spencer

Field: YourDateField
Criteria: Between DateSerial(Year(Date()),Month(Date()),1) and Now()
 
Top