From: Dennis on 8 Feb 2010 21:54 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
First
|
Prev
|
Pages: 1 2 Prev: Excel Embedded Object not Updating Next: Order Entry type form to add to three tables |