I've googled this and found several explanations on how to do this. But none of them seem to deal with the case where there are multiple fields.
Example:
I have a table with a dozen columns. One of them is a date field. One of them is a transaction ID.
I want to return a record for each transaction ID with the earliest date field.
Logically, I would think I would do "group by" on the transaction ID then "min" on the date field.
This doesn't work, and I imagine it's because when I turn on the group by all of the fields have "group by" applied to them.
I really don't understand how the group by feature works in access design view.
I want the first record for each transaction ID. first meaning first date in the date field.
Example:
I have a table with a dozen columns. One of them is a date field. One of them is a transaction ID.
I want to return a record for each transaction ID with the earliest date field.
Logically, I would think I would do "group by" on the transaction ID then "min" on the date field.
This doesn't work, and I imagine it's because when I turn on the group by all of the fields have "group by" applied to them.
I really don't understand how the group by feature works in access design view.
I want the first record for each transaction ID. first meaning first date in the date field.