2 types of Criteria?

[giggs11]

I was wondering if it was possible to have 2 criteria's when running a query? I want to prompt the user to specify a date range and also have a running total. (i.e Totals for month of Feb and also a running total from Nov - Current date). Is this possible?

 

[BNPMike]

You can have two criteria. Choose your field and put the two criteria under each other. That gives Criterion1 OR Criterion2.

 

[giggs11]

Thanks. But now how do i show them on the reports? I need one text box showing the Criteria 1(current month) and another showing Criteria 2 (YTD) totals? Also, how would i but in criteria for NOv 1/03 - now? i tried >=11/01/03 and "now".