problem with query

[kiethb]

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

[CraigDolphin]

Simplest would be:

Select Top 1 *
From YourTableName
Order By [DateFieldName] ASC;

[kiethb]

Problem with that is that there are an indeterminate number of records with the same MIN date... Hard to believe this is that difficult.... I have to be missing something. this is question 2 out of 10, and 3 through 10 are easy... alright, well if there are any other gurus out there that might have an idea what I am missing, let me know! thanks

[CraigDolphin]

Hang on. I thought you said you wanted to return exactly one record ("the record "), that has the minimum date value. The query I provided does that.

If instead you mean that you want to return ALL records that happen to share the same date value as the minimum in the table, then that's a different question with a different answer.

Select *
From YourTableName
Where ([DateFieldName] = DMin("[DateFieldName]","YourTableName"));