Queiry expression bulider

F

Fitz

Hi there -is it possible in a query that if the value in one field "is not
null" to read true in a check box in another field within the same query.
Thanks
 
O

Ofer

I'm not sure if that what you are asking for, but try that

Select MyField, iif(isnull(MyField),False,True) as FieldTrueFalse From MyTable
 
F

Fitz

Hello again,I will explain in more detail.
One of the fields is called date and the other is frame seen(Tickbox).When
data is entered into date I need frame seen to read true.
I am only learning so basic would be helpful.
Thanks
 
O

Ofer

I'm not sure that it's possible to display a field in a query as a TickBox,
but the example I gave you will display the field with True/False

I will give the sql again, if you insist in a TickBox then mybe you will get
a better answer by somebody else.

Select Mydate , iif(isnull(Mydate),False ,True) as MyDateTrue From MyTable

It is better not to use a field name "date" it a reserve name in access, so
you better change the field name.
 
Top