hi

i'm doing a mini-library datebase and one of my queries is to "find all the books shorter than 500 pages, arrange the authors in alphabetical order, and display each author once only." now my questions is at displaying each author once only. How do i accomplish that? :confused: Please help. Thanks you :)

Create a query for the required data, and then create a group report on that query. Group on the Author.

Or, if you just want a query, use an aggregate function like Max, or First on the book data. This will return just one record per author.

thanks alot! :)