UtterAccess Discussion Forums > sorting duplicate names in a form

Full Version: sorting duplicate names in a form

UtterAccess Discussion Forums > Microsoft® Access > Access Forms

emoorehead

Oct 19 2005, 01:04 AM

I am new to access 2003 and have created a form for a client information db. I have created a search by last name field so that I can go directly to that clients information, but if I have a duplicate last name it will not go to the next name. Under the Row Source I have enter this code:

SELECT [Client Information].MailingListID, [Client Information].LastName FROM [Client Information];

Any help would be appreciated.

emoorehead

Oct 20 2005, 10:41 AM

Did I not form my question correctly, or is my problem bigger then a simple fix?

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.