Access Wildcard Search

[cdawley4]

Hi,

I am modifying a database and I want to create a Wildcard Search Query in MS Access. The database has city and the state they reside in. I have about 500 records. I want to see the records that contain Miami anywhere in the record. I also want a dialog box to pop up so I can search for it. I also want to have a wildcard search so I can narrow the search down and find records that have Mia* and still pull up Miami records. I have seen this done on other databases but not sure how it is done. Please help.

Thanks,

Chris

 

[dhookom]

You can set up a calculated column like:
SearchMe:[Address]&[City]&[State]
Then set the criteria under this column to:
Like "*" & [Enter Search] & "*"

Duane
MS Access MVP
Find out how to get great answers faq219-2884.