Access 2003- Help with Query to search a number of fields in db!!

E26 · 14-07-2011 03:57PM #1

Hey,
Would anyone be able to advise the best way to do the following.
I have a table called clients- that contains the usual information ie client name, address fields, county, tel no etc. Am looking to create a query that searches all the address fields and locates the address word i type into the pop up box. any advise much appreciated

FSL · 18-07-2011 10:02AM

SELECT whatever you want FROM your database table WHERE your search criteria matches.

If you are searching for a word or phrase use LIKE.
i.e. where field name LIKE '%your word/phrase%'

The % at the beginning signifies the field can have anything before the selection criteria and the % at the end means the field can have any thing after the selection criteria.

Either % can be omitted to determine how much other than the search criteria may be contained in the field.

1qTour · 18-07-2011 07:46PM

SQL might look something like...

SELECT COUNT(*) as NumRecords WHERE Address1 LIKE '%SearchWord%' OR Address2 LIKE '%SearchWord%' OR Address3 LIKE '%SearchWord%';

The '%' wildcard might be '*' while using directly from access. This will return the number of records that match the search criteria not the actual records.

E26 · 20-07-2011 09:12AM

Thanks a mill for the replies- got it sorted:)

Access 2003- Help with Query to search a number of fields in db!!

Comments