null to zero access 2.0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do you convert null to zero in a query that sums other queries where to i
put the code in to convert the null to zero and what is the code

i would appreciate the help immensely

thanks
 
1. Click the Modules tab of the Database window.

2. Click New. Access opens a code window.

3. Paste in the code from this link:
http://members.iinet.net.au/~allenbrowne/func-03.html

4. Save the module with a name such as "Module1".

You can now use the Null2Zero() function in your query, or in the Control
Source of a text box on a form/report, just like a built-in function.
 
Hi,


Another alternative is to use


iif( myExpression Is Null, 0, myExpression)


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top