Query with 24 calculation freezes. What are the possible causes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
AbrahamRivera said:
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?
Click to expand...

Hi Abraham,

Pretty tough to say for sure w/o seeing data and query stmts.

As a general method, I might make a copy of the query.

Remove the calculating fields and verify works properly.

Then change this query to a make table query.

Run the make table query.

Add one calculating field to this new table.

Run update query on this new table to calculate this field.

Repeat individually for all 24 calculated fields verifying works properly.

If nothing shows up in this process, then change update query
to change all 24 fields at same time. Test if works properly.

If nothing erroneous shows up again, then I might think about
changing your original make-table query to an append
query.

In VBA,

Delete all records in new table.

Run append query.

Run update query that updates all 24 caculated fields.

Use this new table where you would have used the
original query.

Well... just one suggestion...

Good luck,

Gary Walter
 
Back
Top