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
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