Monday, 14 March 2011

Searching for a blank field

Sometimes you want to search for fields which have been left blank - say you've put the date a job was completed on.

All you do is add the criteria of Is Null (the space is important!!!) and it'll do it.

Personally I'd tend to suggest using a Yes/No field to record if it's been paid for this sort of thing, but sometimes client needs mean you need to record the actual date.

No comments: