check boxes help

[hollyh]

I inherited a database and I'm new so bare with me

The database uses a lot of check boxes

when i query one table the check boxes come back as -1 or 0 or blank
when i query another table the check boxes show up in the actual query results (annoying)

is there a way to disable the check boxes from showing up in the query results but show actual values?

thanks!

 

[vapid2323]

Uncheck the box that says "Show" when your in the Query design view?

 

[hollyh]

i want it to show a -1 a 0 or a blank like first one..is that possible?

 

[vapid2323]

i want it to show a -1 a 0 or a blank like first one..is that possible?

Sounds like one query is for a table on a SQL server and another is from directly in access.

Thats the only way I have seen the value change, so thats a good question I am not sure.

 

[hollyh]

actually, i get it..sort of, one query that shows the number values is based on IIF statements

what I don't get is these fields have null values too so why on earth would they use a check box

i see how to change it to yes/no on the table but id still rather have a number without screwing up the form. i guess theres no quick answer