Hi, again
FieldTripInformation is the table, fieldtripstatus is the field and it is not a memo field. Most of the memo fields in the field trip select field names are comment(s), or instruction(s).

>Also, is UPPER(FIELDTRIPINFORMATION.FIELDTRIPSTATUS) = "SCHEDULED" FieldTripInformation is a Memo field? If so, it may be a problem. I would probably compare upper(left(...,9)) = "SCHEDULED"
>