If/Then Query

[jo15765]

I have a form, and on this form, there is a tick box for of course "Yes" and "No." I want to be able to query off of this tick box, and show the records, that are checked as "yes" in one query, and then the records checked "no" in another query. How do I do this?!

[ajetrumpet]

you can't do this with 2 different queries easily. you'll need 2 differents.

[jo15765]

How would I set it up to display in two sepeate queries?

[ajetrumpet]

what you want is unclear. but say you had a table with a "yes/no" column in it and you wqnt to query based off of the tickbox in the form. I would assume this would work:

select whatever from table

where yesnofield = iif(forms!formname!tickbox = -1, -1, 0)

[jo15765]

i have a tickbox that i will check if the documents are originals. i am wating to build 2 queries; one that will display all of the checked boxes, and one that will display the non-checked boxes. does that make more sense on what i am needing? thanks again!