I am trying to help my friend with her homework. She has a small table created. her task was to pull the record with the earliest date. we grouped it by MIN and ran the query, it will only show the field I grouped by, I can not seem to get it to run if I select the rest of the fields. Can someone tell me what I am doing wrong? I need to be able to simply query the table and pull out the entire record for all dates matching the earliest... thank you