Child records

[D]

Our Access2K DB uses a function to string together child
records from a table. When I run a query it
slowly "repaints" the records when I scroll horizontally
to view the full sheet. I noticed the same thing in the
Northwind database on qryCombineProducts (from where the
function probably came)it just doesn't appear to be as
slow. Any ideas on how I can speed up the query?

 

[Jeff Boyce]

Without some idea of what you have in your tables, or what your "function to
string together child records" is doing, or what your query is doing, it
could be tough to offer meaningful advice...

But sometimes a slow query will speed up if the underlying tables' fields
used to join, select and sort are indexed. Are your underlying fields
indexed?