Table-validation rule.

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

Guest

If i have data in one field can I validate that another field reads yes and
if null reads no.The field that has data is called date,the yes/no column is
called frame seen.
 
You shouldn't have the Field [Frame Seen] in the Table. It is completely
dependent on the Field [Date] and there for it is a Calculated Value and
Calculated Values should not be stored in the Table in general.

BTW, [Date] is a bad Filed name since Date is the name of the in-built
function Date(). Using [Date] as the Field name will get very confusing
(for you) when you write VBA code.

HTH
Van T. Dinh
MVP (Access)
 
I feeel I am now getting somewhere,can I do this using a query/If so what is
the formula for the expression builder query code?
Thanks
 
Create a Calculated Column in your Query using the following expression:

FrameSeen: IsDate([OurDateField])

Set the Format Property of this Field to "Yes/No".

--
HTH
Van T. Dinh
MVP (Access)
 
Back
Top