jprockbelly
New member
- Local time
- Tomorrow, 03:10
- Joined
- May 18, 2010
- Messages
- 8
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 those in "deep_drain" except all negative numbers are replaced by a 0.
Any help is appreciated.
thanks
JP
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 those in "deep_drain" except all negative numbers are replaced by a 0.
Any help is appreciated.
thanks
JP