Re: How do I return record with earliest date?
This requires two. Queries, what is happening to you is that the query is grouping on all fields and therefore the differences in those fields, so
Query1 just select transactionid and date fields group by transactionid and min on date field.
This gives the min date for each transactionid so now quer u2 takes in the table and query1 joined on transactionid and date fields and you can select any other data that you require.
Note that you just run query2 the system automatically runs query1
What is this life if, full of care,
We have no time to stand and stare
I do not have Access these days 2015