Thanks Alan. It's not working. I am sure it is due to my ignorance of access.
I am entering this in the criteria box of the field of the query I want to filter in design view. Is that correct? When I run the query after entering this I get zero records. There are lots of records in the table of source data that should match this criteria.