If you are talking about things like DCount, DMax, and such, they can be
really slow if you have a lot (like 50,000+) records. I tend to avoid them if
possible.

On the other hand, Totals queries are very useful to summerize data.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"AccessKay" wrote:

I’m fairly new to Access so this may be an inane question to all those
experienced people out there. My question is about the use of aggregates in
a query. I’m noticing that designing queries with aggregates might lead to
problems. Is it best to not build queries with aggregates if you can avoid
it?

Thanks for any feedback.