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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Criteria from forms

Status
Not open for further replies.
risoam

risoam

MIS
Apr 17, 2002
33
US
I have a query that I may or may not want to specify a date range criteria depending on whether the date range fields on the form are empty. I tried using and if but that didnt seem to work. Does anyone know how to do this without using multiple queries?
 
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
759
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
603
mikrom
mikrom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid
qqp
  • Locked
  • Question
Query criteria from form
Replies
9
Views
572
qqp
qqp
TrekBiker
  • Locked
  • Question
Select addresses using two criteria, one 'Like" 2
Replies
3
Views
505
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top