Building my first database application to organize articles for a web site. What I am trying to do is show the newest article for each author in the database. Each author has a unique AuthorID, and each article has an ArticleDate. I am wondering if there is an SQL statement that will allow me to create a recordset of 1 article (the newest article) per author. I would appreciate any help or suggestions, please let me know if any more information is needed. Thanks.