Problem with Group By & Max Rcd
Tom,
I now understand "Group By" queries are always read-only. I kind of figured
that when I could not enter data in the query.
My subform is trying to show the latest Transaction for the current
customer. It was suggested that I do a Group By query and get the
Max(ExpirationDate). However, since that approach does not allow to me enter
data. So the question is how do I determine the "latest transaction" for a
customer and still allow data entry?
---
Dennis
|