Hello,
I have a report based on a UNION query. The report has DSum() and DLookup() functions. The query works fine, but when I run the report it just hangs on "Formatting Page press Ctrl + Break to stop". Cheers for any help!Thank you.

You just have to wait long enough. Putting a bunch of domain aggregates and then into a union query is sure enough to slow your stuff down to breakneck "snail speed." Especially if you have any code, groupings, etc. on the report.

Thank you Bob.