Results 1 to 2 of 2
  1. #1
    Scorpio11 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Location
    Cape Town, ZAR
    Posts
    36

    Query SQL Crash


    The Query crashes when i run the sum. The query that is giving me problems is called Qry:Sec_Income

  2. #2
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    I did some cleanup on your tables and then reworked your queries accordingly. However, even with that I could not get the last query to work properly, so I decided to create a custom function that does the cummulative sums for dividend and interest. In the process, I might have messed up your queries such that they are probably not providing the data you wanted, as a result, I'm not sure whether the custom function is returning what you want either. Could you please review the sequence of queries to make sure that the correct data is being returned; please make any necessary corrections. With respect to the dividend and interest sums, you will have to explain in words what criteria is necessary to generate the sum & from there I might have to alter the custom function. The DB is attached.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to make a query Crash?
    By techexpressinc in forum Queries
    Replies: 5
    Last Post: 03-09-2010, 01:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums