Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

2 types of Criteria?

Status
Not open for further replies.
giggs11

giggs11

Programmer
Dec 5, 2001
21
CA
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?
 
Sort by date Sort by votes
You can have two criteria. Choose your field and put the two criteria under each other. That gives Criterion1 OR Criterion2.

 
Upvote 0 Downvote
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".
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
173
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
113
caykamanj1966
caykamanj1966
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
234
PrimoSteve
PrimoSteve
priac
  • Locked
  • Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
533
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Use combo on form's tab page as query criteria
Replies
5
Views
95
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top