|
Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word? Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word 
Host your Web site with PureHost! 
|
 
Saturday, July 11, 2015 – Permalink – Make Null ZeroIt's nothingWhen it is desirable to return a zero (or another value) rather than an empty field, Access (Visual Basic) has a function Nz(): Nz(variant, [valueifnull]) The Nz function has the following arguments.
This example demonstrates how you can simplify an IIF function Instead of: varTemp = IIf(IsNull(varFreight), 0, varFreight)You could use: varResult = IIf(Nz(varFreight) > 50, "High", "Low") Helen Feddema offers a suggestion about forcing a zero when Nz() doesn't work When you want to display zeroes in text boxes (or datasheet columns) when there is no value in a field, the standard method is to surround the value with the Nz() function, to convert a Null value to a zero. However, this doesn't always work, especially in Access 2003, which is much more data type-sensitive than previous versions. In these cases, you can force a zero to appear instead of a blank by using two functions: first Nz() and then the appropriate numeric data type conversion function, such as CLng or CDbl. Here is a sample expression that will yield a zero when appropriate: Download a sample from: ACCESS Watch See all Topics access Labels: Functions, General, Macros, Reference, Shortcuts, Tips, Tutorials, VBA <Doug Klippert@ 3:09 AM
Comments:
Post a Comment
|
