SELECT DISTINCT in one field
Posted on 2003-02-28
Here is a query i'm using in a combobox to find records in a subform.
SELECT [accession record].[Accession number], [Author] FROM [accession record];
accession recrod is the primary key, so i need it in the query for linking child fields in the subform.
The results i get in the combobox are something like this..(accession record is hidden, only author is seen)
now i thought of using a SELECT DISTINCT, but it doesnt work because the 'accession number'(primary) is distinct anyways.
so what i need is a query that gives me the DISTINCT authors,but i also need it to return the accession numbers because of the 'link child fields' as i said above.