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
Ben Sugden
"Remember to enjoy hunting - and that means relishing the search for the product that has never been advertised or placed handily at the front of the shop; Life begins on the uppermost shelf, avoid guide books and top 10's like the plague." - Ramsey Dukes