Question check for empty option group field

[byTimber]

Hi All,

I have an simple option group (3 options 1,2 and3!!)

I am building a query where I need to display records whose option group field in the table is empty.
I have tried:

field = Int(0)
field = ""
field = null
isempty(field)

do not work - what am I missing?

 

[John Big Booty]

Option Groups have a Frame, you need to find the name of the Frame that encloses your Option Group and test that.

 

[byTimber]

Thanks for reply JBB but I am trying to get the value (empty value) of the field to which the frame containing the option group is linked. I can quiz the table for values 1, 2 and 3 ok and get the names of these people but the people whose option group field is empty I cannot seem to get.

I have tried < get the fields which are NOT 1, 2 or 3 > but then I get nothing at all.

So to summarise, I cannot identify an empty number field in the table.

:banghead:

 

[John Big Booty]

An option group by definition can only have one option selected. So if you know which one has been selected, by a process of elimination you know what has not been selected.

 

[byTimber]

Got it Now!!!!


field Is Null produces the result...

Thanks JBB...