filter on a name with a & in it

[Pooh]

Hi

I select a name from a drop down list that looks like this:

Lockley & Smith Ltd

When the query runs it does not return the Lockley & Smith Ltd records. It does not return any records and changes the name I have filtered to 'Lockley' & 'Smith' - how can I get it to look for Lockley & Smith instead of 'Lockley' & 'Smith'?

Many thanks

 

[neileg]

Sounds like a design flaw. You should have an ID associated with the names and select the records by ID not name. The characters in the name are then irrelevant.

 

[Pooh]

Thanks, you said enough to point me in the right direction - doh! all seems so obvious now.

 

[Dennisk]

surround the name in single quotes