ALL criteria in a query

  • Thread starter Thread starter Jade
  • Start date Start date
J

Jade

In my query, one of the field's has criteria that points
to a text field on a form. That text field checks
whether or not a check box on that form is checked. It
says that if it's checked, make the text field equal
to "A" else make it pull all from the query as if there
was no criteria. I don't know how to get it to pull all
if the check box isn't checked. If I say:
IIf ([CheckBox]=1,"A","")
then if the check box isn't checked, the query is looking
for a null value but I want it to pull everything. Is
there a symbol that's used to pull everything? Thanks
for the help in advance.

Jade
 
Jade,

I don't know your Form name, but some variation of this in
your query criteria should work in checking the checkbox
directly...

Like IIf([Forms]![YourForm]![CheckBox]=True,"A","*")

Gary Miller
Sisters, OR
 
Back
Top