Hi Chris,

Don't use the fields at all in the statement... You can't have the equivalent of a blank string for Logical or Date/Datetime datatypes... you coiuld try

!ISNULL(fieldname) but I'm not sure that would work. Your best bet is to not reference the field at all.

If you want to return a list of all records with a description field matching the word "Fox" but for any date just remove the "AND Date =" section. If you're doing this you may be better off building the entire where clause rather than each section of it... if you see what I mean.

Cheers,

Ben