Lynn_AccessUser
Registered User.
- Local time
- Today, 15:45
- Joined
- Feb 4, 2003
- Messages
- 125
I have a query with ID, lastname, firstname, partnerlastname, and orders.
The user can search on any field. The problem is that say for instance the user searches on partnerlastname = Test it returns 3 records for lastname = Doe and firstname = John because John Doe has 3 order records. The query is being used to populate a listbox that only shows the lastname and firstname so I only want John Doe to appear once in the listbox even though he may have 3 order records.
Any suggestions?
The user can search on any field. The problem is that say for instance the user searches on partnerlastname = Test it returns 3 records for lastname = Doe and firstname = John because John Doe has 3 order records. The query is being used to populate a listbox that only shows the lastname and firstname so I only want John Doe to appear once in the listbox even though he may have 3 order records.
Any suggestions?
