Searching for Peoples Names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top