View Single Post
  #6  
Old February 9th, 2010, 02:54 AM posted to microsoft.public.access.tablesdbdesign
Dennis
external usenet poster
 
Posts: 1,222
Default 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