Getting "Check Box" Information in a Query

[Guest]

Hello- I have a query built and in this query I would like to add
information that is in the format of check boxes (so in my table they are set
up as a check box). When I run my query I would like to add, if a box is
checked what this check box means. The names of the check boxes are
"chkAction1", "chkAction2", "chkAction3" and so on. Each of these "actions
check boxes" has a definition, and if the box is checked then in my query I
would like to know the definition of the box (if checked). What kind of
statement would I put in my query to let it know, that if check box 1 is
checked, then list the definition of check box 1?

I hope my question makes sense! Your help is appreciated! Thanks

 

[fredg]

Hello- I have a query built and in this query I would like to add
information that is in the format of check boxes (so in my table they are set
up as a check box). When I run my query I would like to add, if a box is
checked what this check box means. The names of the check boxes are
"chkAction1", "chkAction2", "chkAction3" and so on. Each of these "actions
check boxes" has a definition, and if the box is checked then in my query I
would like to know the definition of the box (if checked). What kind of
statement would I put in my query to let it know, that if check box 1 is
checked, then list the definition of check box 1?

I hope my question makes sense! Your help is appreciated! Thanks

Each in it's own coulumn:

CHK1:IIf([chkAction1]=-1,"This","That")
CHK2:IIf([chkAction2]=-1,"Up","Down")

 

[Guest]

Hi! I have pretty much the same question, but having a small glitch. I'm
working in the query grid trying to pull the information from only the boxes
that have been checked on a form for a customer survey. I took the advice
that was given here, but the way I took it was this:

So, what I've got is chkTopBottom in field name, table is tblSurvey, and in
criteria I have IIf([chkTopBottom]=-1,"Yes,"No"). The error I get says "Data
type is mismatch in criteria expression." *so*, my question is what does
that mean, how do I fix it, and am I even on the right track here?

Thanks!
Seren

Hello- I have a query built and in this query I would like to add
information that is in the format of check boxes (so in my table they are set
up as a check box). When I run my query I would like to add, if a box is
checked what this check box means. The names of the check boxes are
"chkAction1", "chkAction2", "chkAction3" and so on. Each of these "actions
check boxes" has a definition, and if the box is checked then in my query I
would like to know the definition of the box (if checked). What kind of
statement would I put in my query to let it know, that if check box 1 is
checked, then list the definition of check box 1?

I hope my question makes sense! Your help is appreciated! Thanks

Each in it's own coulumn:

CHK1:IIf([chkAction1]=-1,"This","That")
CHK2:IIf([chkAction2]=-1,"Up","Down")