Access

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

When designing a query to give a list of authors from
books table, how do I arrange it so each author is only
shown once, even though they may appear several times in
the table?
 
What you should have is two tables:

Books Table
***********
AuthorID
Title
ISBN

Authors Table
*************
AuthorID
Surname
FirstNames

And link the two together on the "AuthorID" field, but it's obvious you have
not done this, so use SQL like this:

SELECT DISTINCT Author
FROM MyBadlyDesignedTable;

You can add an "ORDER BY" clause to it as well if you like (and you have
Surname in a seperate field or "Surname, FirstNmes")
 
Back
Top