Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Queries > Nz and whole nu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 41165 of 43104
Post > Topic >>

Nz and whole numbers

by jlute@[EMAIL PROTECTED] Aug 5, 2008 at 05:38 AM

UNNtWt: IIf([UNNtWtConvgal],Nz([INGDenlbgal],
[FADenlbgal]*[UNNtWtConvgal]))

This returns a value only if a UNNtWtConvgal is a whole number.

Does anybody see why this is? Have I done something wrong with Nz? I
simply want to calculate INGDenlbgal or FADenlbgal with UNNtWtConvgal
if it has a value.

Thanks in advance!!!
 




 8 Posts in Topic:
Nz and whole numbers
jlute@[EMAIL PROTECTED]   2008-08-05 05:38:05 
Re: Nz and whole numbers
"Michel Walsh"   2008-08-05 09:02:15 
Re: Nz and whole numbers
"Bob Barrows [MVP]&q  2008-08-05 09:07:03 
Re: Nz and whole numbers
jlute@[EMAIL PROTECTED]   2008-08-05 07:03:37 
Re: Nz and whole numbers
"Michel Walsh"   2008-08-05 10:58:24 
Re: Nz and whole numbers
jlute@[EMAIL PROTECTED]   2008-08-05 08:37:18 
Re: Nz and whole numbers
"Michel Walsh"   2008-08-05 13:04:41 
Re: Nz and whole numbers
jlute@[EMAIL PROTECTED]   2008-08-05 10:32:33 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Nov 20 21:35:11 CST 2008.