If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
"AbrahamRivera" wrote:
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? 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
Calculation in Group query | Ellan | Running & Setting Up Queries | 1 | August 13th, 2004 06:46 PM |
Compound interest calculation in a query | Ray Gunderson | General Discussion | 2 | August 9th, 2004 02:57 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |