Search results

Bingo. I knew it had to be something simple. Thanks!!

Sadly, still #error. I tried some other similar queries as well and I have the same result. The other thing is that the result comes back almost instantly, when actually running the query for the full recordset should take a fair amount of time - a few minutes at least. This makes me think it's...

Yup, all that's handled in the table definition. In addition I've tried it selecting for a single record with known (valid) values. I also tried just passing values directly in the query e.g. plot_live_C(1,1010,1) and had the same problem. There must be something I'm missing...

I've written a function that takes three integers and returns a double. Any time I try to call it from a query it returns an error; select query will return #error, update or make table return a type conversion failure. ?? 1) The code works fine when run in the immediate window of VBA editor...

jdraw, Thanks for taking the time to do that. That will work well for the living trees. The trick will be a preceeding step to calculate height from diameter where height was not measured, and a subsequent exponential decay function for dead trees, but I suspect I can work it out. My lessons...

Alright, here goes. I need to be able to call this on a record-by-record basis, but there are only a handful of values in the equation parameter table. I wonder how to avoid opening a recordset based on that table each time the function is called, so I was thinking either a module level array...

jdraw, Thanks for the reply. As the project is currently organized my function (let's call it Carbon) is called on a tree by tree basis, but eventually all trees get calculated. Basically I have a procedure that iteratively selects a subset of trees, cleans up bad/missing data, calls the...

Hello all. First of all, thanks to all the knowledgeable folks out there willing to contribute. I've learned quite a bit as a lurker. I have a function that is passed some information about a tree, including the species. This function performs a simple calculation on the information passed...