Thread: Expression Builder : MS ACCESS FORMS
View Single Post
•
•
Join Date: Mar 2007
Posts: 306
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 26
timothybard's Avatar
timothybard timothybard is offline Offline
Posting Whiz

Re: Expression Builder : MS ACCESS FORMS

 
0
  #2
Nov 26th, 2008
You can use the NZ function:

nz([Weight_Likely],0)

The nz function will function will return [Weight_Likely] if it is not null. If it is null, it will return 0.
http://www.timothybard.com
http://www.oliveirabard.com
Reply With Quote