Query - Default choices

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I have a query where I choose based on criteria from a
table.
The item I am choosing from has items as A B C D
I want to choose either A or B when running a query,
however if I do not choose, then I want the query to run
showing all A's and B's - and not include C's or D's.

How can I put this into my query?
Thanks
Sam
 
Hi,



WHERE (( FORMS!FormName!ControlName Is NULL AND FieldName IN ('A', 'B') ) OR
FieldName=FORMS!FormName!ControlName)




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top