A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #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?

  #2  
Old October 13th, 2004, 01:30 PM
Gary Walter
external usenet poster
 
Posts: n/a
Default

"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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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
Print 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


All times are GMT +1. The time now is 05:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.