Query with 24 calculation freezes. What are the possible causes?
One of the queries of a DB I'm developing reads from two tables and two
queries and includes 24 calculated fields. Although the calculations are not
complex (simple additions and substractions), they seem to be long. When I
try to run this query, Access freezes and the only way to end the program is
ALT/CTRL/DEL and cancel the program.
What are the possible causes of this problem?
Do you any suggestion regarding potential remedies?
|