Search results

Still no null values found. I should also elaborate on the error generated by the above code. When I do get an error it is either, 3043 'Disk or network Error', 3218 'Could not update', or 3024 'Cannot find file'. This also happen after an arbitary number of records have been generated, but...

Yes, deep_drain is a numeric field, doubles, ranging mostly from roughly 12 to -9. Hence 9999 as a flag. No, this query did not return any 9999 values.

Thank you, now I understand. To look for null values I have used the query ErrChk: Nz([deep_drain], 9999) However, this query does not return any null values in the field deep_drain.

You will have to n00b this up for me. Is this implemented via VBA? How do I execute this code? Sorry, I'm quite new to Access

Thanks for the replies guys. 1. So this works great for for a small sample of the data (thanks for the tip): !deep_drain_filt = IIf(!deep_drain > 0, !deep_drain, 0) Yet when I try to run it with the entire table I get an error. This seems to be because the table is very large >2 million...

rb2006, thanks for the help. This should set me on the path

Hi all, Bare with me I'm quite new to code in Access. I have a table, "h_al_871_val", which contains a field, "deep_drain". This field contains doubles ranging from about 12 to -9. I would like some code which adds a field to the table and fills it with values. The values are the same as...

Hi All, Been reading a few posts and decided to join. I mostly work in Excel but now some new work requirements mean that I have to make the move to Access. I view this as a good thing, the more I use access the more I like it. Anyway, I am mostly interested in learning to write code for...