Approval checkbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two (rejected) checkboxes for approval.

If either one of these or both are checked then I would like it to show in
my query.
If they are not checked of course I don't want it to show in my query.

I can't figure it out...What am I missing.....

Thanks!
 
Create a new field in the query adding both CheckBoxes

AddingCB: Nz([rejected1],0) + Nz([rejected2],0)

In the criteria under this new field write write
<>0

As SQL it will look like

Select * From TableNAme Where Nz([rejected1],0) + Nz([rejected2],0) <> 0
 
Back
Top