Queiry expression bulider

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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.
 
Back
Top