Recent content by blinddestiny

Thanks datAdrenaline, The script you gave didn't quite get the result I wanted but I have managed to get qryPaymentStatement and qryPaymentStatementArrears down to one query using it as a guide. Below is the edited script. Going to see what I can do to get qryPaymentStatementCumArrears and...

After some experimentation and disection, it'll work successfully up to " AND ((q.[arrears])>0))" it will crash whilst applying this command. If I remove that line and use the last line "ORDER BY unit.unitref" this will crash it as well. So basically my refined script of: SELECT q.paymentid...

Hi Guys, Wondering if anyone can help me with some deciphering of code. In short I am working with Access and trying to run a report that ends up using 100% of the cpu and eventually having to force quit the application. I have found the source of the problem and code below, but having trouble...