Hello
I am trying to write a databse which allows me to track the amount of various gasses in oil samples. With this data I want to be able to trend the results and also perform some simple calculations on it.
I have managed to carry out the calculations ( a simple a/b calculation) using a query, but I then want to run another query which only displays the results which are greater than 10. When I run the query I get a divide by zero error, and error, followed by a stack overflow error.
I get some #Error values during the initial calculation stages – could this be the cause? I have tried implementing the NZ function but I don’t seem to have got the syntax correct as it still gives me #Error in the calculation query.
Am I asking too much from Access to do this for me? Should I just stick with my spreadsheet? Any help and/or advice would be greatly appreciated.
Thanks
Ian
