View Single Post
  #1  
Old October 13th, 2004, 02:53 AM
AbrahamRivera
external usenet poster
 
Posts: n/a
Default 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?