Criteria - Query

[Guest]

I have set up a database with a 'address' query.

The query contains the criteria - [Enter the address:]

This criteria works providing the user enters the correct full address e.g.
Mr Bull, 10 High Street London WS34 5FT to search for the record.

I want the user to search for a record by enterting part of the address e.g.
High Street.

Any ideas?

 

[Allen Browne]

Change the Criteria row in your query to:

Like "*" & [Enter the address:] & "*"

 

[Guest]

Mr. Bull should not be in the address field. The same goes for city and
postal code.
The best layout for name is like --
LName
First
Middle
Suffix -- SR, JR, ESQ, IV, etc.
Title -- Mr, Mrs, Miss, MS, Mister, Master, Mistress, Highness, Your Honour,
etc.