Still Learning, can I do this?

[Jeff Uchtman]

I have 3 different check box's on a DB query display. Can I check all 3
fields and if all are <null>, base my display verses if all are on or a
mixture of on and off?

Thanks
Jeff

[Ray at]

Yes, you can do this. I guess one thing to know/remember is:

True + True + True = True
True + True + False = False
True + False + False = False
False + False + False = False

Are your values really null though? By checkboxes, do you mean "yes/no"
fields in an Access database? If so, CBool the values when you bring them
out to be sure that there boolean true/false values.

Ray at home

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:Oi**************@TK2MSFTNGP12.phx.gbl...

I have 3 different check box's on a DB query display. Can I check all 3
fields and if all are <null>, base my display verses if all are on or a
mixture of on and off?

Thanks
Jeff

[Jeff Uchtman]

Thanks Ray at where ever you are right now. Yes, I am <null> as its MSSQL
using a bit format. I beleive I understand the direction you pointed out
and will see if I can make it work. Thanks for the input.

Jeff

"Ray at <%=sLocation%>" <myFirstNameATlane34dotKOMM> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Yes, you can do this. I guess one thing to know/remember is:

True + True + True = True
True + True + False = False
True + False + False = False
False + False + False = False

Are your values really null though? By checkboxes, do you mean "yes/no"
fields in an Access database? If so, CBool the values when you bring them
out to be sure that there boolean true/false values.

Ray at home

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:Oi**************@TK2MSFTNGP12.phx.gbl...

I have 3 different check box's on a DB query display. Can I check all 3
fields and if all are <null>, base my display verses if all are on or a
mixture of on and off?

Thanks
Jeff

[Ray at]

If you factor in nulls, there's also this to consider:

null And null = null
null And false = false
null and true = null

Ray at home

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:u5**************@TK2MSFTNGP09.phx.gbl...

Thanks Ray at where ever you are right now. Yes, I am <null> as its MSSQL
using a bit format. I beleive I understand the direction you pointed out
and will see if I can make it work. Thanks for the input.

Jeff

"Ray at <%=sLocation%>" <myFirstNameATlane34dotKOMM> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Yes, you can do this. I guess one thing to know/remember is:

True + True + True = True
True + True + False = False
True + False + False = False
False + False + False = False

Are your values really null though? By checkboxes, do you mean "yes/no"
fields in an Access database? If so, CBool the values when you bring them out to be sure that there boolean true/false values.

Ray at home

"Jeff Uchtman" <uc*****@megavision.com> wrote in message
news:Oi**************@TK2MSFTNGP12.phx.gbl...

I have 3 different check box's on a DB query display. Can I check all 3 fields and if all are <null>, base my display verses if all are on or a mixture of on and off?

Thanks
Jeff