Re: How do I read delete and write records in Access modules?
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 16 Aug 2007 19:42:33 -0600
On Thu, 16 Aug 2007 17:48:49 -0700, Jerry McNabb
<JerryMcNabb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
What is the NZ function? I've never seen it before and I can't find it in
"help" or in any books I have.
It's in the VBA help file, not the Access user-interface help. Open the VBA
editor (ctrl-G) and look for help there.
Pretty simple:
NZ(<value>, <optional argument>)
returns the value of the optional argument if value is NULL, and just returns
the value otherwise. If you leave out the second argument it returns 0 if the
value is numeric, and an empty string "" if it is text.
John W. Vinson [MVP]
.
- References:
- Re: How do I read delete and write records in Access modules?
- From: John W . Vinson
- Re: How do I read delete and write records in Access modules?
- From: Jerry McNabb
- Re: How do I read delete and write records in Access modules?
- From: John W . Vinson
- Re: How do I read delete and write records in Access modules?
- From: Jerry McNabb
- Re: How do I read delete and write records in Access modules?
- Prev by Date: RE: PLEASE HELP WITH LOG IN FEATURE
- Next by Date: RE: Multi user database
- Previous by thread: Re: How do I read delete and write records in Access modules?
- Next by thread: Re: How can I change Table Attribute programmatically
- Index(es):
