The Query crashes when i run the sum. The query that is giving me problems is called Qry:Sec_Income
The Query crashes when i run the sum. The query that is giving me problems is called Qry:Sec_Income
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.