The more I learn the less I know. I am new to using Access in Office 2003. I
attempted to build a query as follows:
Field: Author
Table: Book List
Criteria: "DISTINCT [Author] FROM tblbooklist"
I must be missing something, because the query opens with nothing in the
box, and when I open the FORM, the drop down list still has multiple entries.
Hope you can help. Thanks John
Klatuu said:
Use a query for the list box row source using Select Distinct. That will
return only one occurance of each author:
SELECT DISTINCT [author] FROM tblAuthors;
--
Dave Hargis, Microsoft Access MVP
:
For an existing database I created a drop down list box on a Form for the
field Author. How do I edit the drop down list to exclude or delete
duplicates?