Searching for Peoples Names

A

Ambu-Al

I am creating a database where I need to search for a person (patient) from a
list of patients in a table.

I have set up a form with a textbox (SurnameFind) and an execute button.
However what is the best query to use, considering I need to search for the
patients by the surname typed - where there may be many or different
spellings!?

Also, once I have the results from my query, is there any way that I can
have those results appear on another form in a list as opposed to the table
view I am getting at the moment??

Any help would be greatly appreciated.

Al
 
S

S.Clark [Access MVP]

You can open a form, then change it's recordsource to be a query based on the
entered criteria. Or use an append query to write to a table, of which the
form is based.

Either method works.

Steve Clark, Access MVP
FMS, Inc
 
Top