Debugging and bypassing errors while running a query

[klar]

Hi Access experts,

I encountered several overflow, divide-by-zero errors while running a query. It is hard to debug this query. The errors occur only on some of the records. If I use breakpoint, it will take a very long time to step through before encountering a problematic record. Did anyone encounter similar problems and any suggestion to debug such a query?

How can I skip the errors while running the query? I have to force-close Access to stop the query from running when the errors appear.

Thank you.

 

[WayneRyan]

klar,

You should build your queries by expanding them, rather than trying the all-at-once approach.

At this point, you can try to isolate problems by REMOVING a column at a time. When you encounter
a problem, you will have to run additional queries to see whether you have to change the query or
the data.

You can't skip the errors. You can remove the division (for research) and use 0 as criteria to
find the offenders.

Wayne

 

[gemma-the-husky]

if you have zeroes, or nulls affecting a calculation, then sort them first. either filter them out of the query, or amend the calculation that uses them, or set a real value

you should not have unhandled data errors. this is all part of the system development process