Totals query as a sub query

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I am trying to make a query to use in a form. The query
brings up contact information. Two fields on the query
come from a sub-query. The sub-query is a 'totals' query
that finds the 'max' contact date for each person and the
contact type.

For instance, it will show that "Jane Doe" was last
contacted on 05/15/2004 and the contact type was "phone".

The problem is that when I include the total query
fields, it then locks all my query fields. I'm unable to
edit anything (which makes the form useless).

Anyone know how I can include the two totals-query fields
without locking my records?

Thanks in advance!
Ron
 
You could replace the sub-query with the very slow DLookup() or other domain
aggregate function.
 
Back
Top