Searching for First and Last Name on Form

[Debbiedo]

I am trying to set up a search feature in an Access form that narrows
the display of selectable options as you type in more information.

I have the basic idea of how to do "starts with" searches for a given
field. What I do not know how to do is combine the results of two
search fields, display the results, and then interatively select the
correct record based on the results displayed.


Thus, I can create a search that selects all records that has the
LastName beginning with Smith.
I can also create a search that has records where the FirstName
begins
with Jo but...


How can I combine these to display all records that contain these two
search results and then from these results pick the correct record to
then display in a report. (e.g Jon Smith-Edwards) The problem is that
there can variations on how the data entry people spell a person's
name and I need a search engine that captures these variations and
ultimately return a single record to display in a report.


Many thanks


Deb

 

[KARL DEWEY]

Try using something like this ---
SELECT EM_List.ID, EM_List.LAST_NAME & " " & EM_List.FIRST_NAME FROM EM_List;

 

[Albert D. Kallal]

I have an example search form that does the first + last name.

grab a copy of my "super easy word merge" here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html


You find a seach form in the above....