Export query issue

[Shaba]

Hello,

I'm having trouble exporting a query, as in it takes a very very long time (at least 1 and a half hours). After that i shut it down

To be fair the query is kind of large:
The firs column is filled with customerID's (over 50000)
Columns 2->32 are DLookUp expressions that populate data for all clients
Columns 33->39 are basically custom functions (Rcounts, Rsums, Average)
The record count is aprox. 1950000.

Here is a link to another post of mine (so you can get an ideea of what my database looks like) where i had some troubles with the custom functions:
https://www.accessforums.net/queries...003-18164.html

I think that the problem is that there are too many Dlookup expressions, this causing the extremely long time to export.

Does anyone know a way to solve this issue?

Thanks in advance!

[Stingaway]

Could you eliminate the DLookups by creating relationships within queries? Not sure what the overhead difference is on them, but it is what I would try.

[Shaba]

Relationships would not help because the data from columns 2->32 is in brought from 31 independent tables.