MS Access and FileMaker Pro RSS MS Access and FileMaker Pro RSS

Expression Builder : MS ACCESS FORMS

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

•
•
Join Date: Feb 2008
Posts: 198
Reputation: dinilkarun is an unknown quantity at this point 
Solved Threads: 0
dinilkarun dinilkarun is offline Offline
Junior Poster

Expression Builder : MS ACCESS FORMS

 
0
  #1
Nov 26th, 2008
Hi,

Please help me with Expression builder for my FOrm.
Weight_likely - back end DB Column
I want an expression, where if Weight_likely is blank then in form 0 should be populated or if Weight_likely has a value then the value itself should be populated.

=IIf([Weight_likely]="",0,[Weight_likely])

Please help me on this.

Regards,
Jagadeep Reddy
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2007
Posts: 305
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 25
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 Quick reply to this message  
•
•
Join Date: Feb 2008
Posts: 198
Reputation: dinilkarun is an unknown quantity at this point 
Solved Threads: 0
dinilkarun dinilkarun is offline Offline
Junior Poster

Re: Expression Builder : MS ACCESS FORMS

 
0
  #3
Nov 27th, 2008
Its not working.Please help me with Expression builder
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2007
Posts: 305
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 25
timothybard's Avatar
timothybard timothybard is offline Offline
Posting Whiz

Re: Expression Builder : MS ACCESS FORMS

 
0
  #4
Nov 27th, 2008
Just type the following in the expression builder:

=NZ([Weight_likely],"Hello")
http://www.timothybard.com
http://www.oliveirabard.com
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2006
Posts: 194
Reputation: HI2Japan is an unknown quantity at this point 
Solved Threads: 21
HI2Japan HI2Japan is offline Offline
Junior Poster

Re: Expression Builder : MS ACCESS FORMS

 
0
  #5
Dec 1st, 2008
If you can't get timothy's suggestion to work, type null rather then "" in your condition.
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum
Thread Tools Search this Thread



access applications at&t blackberry bootup cms community contentmanagement dataaccess ecm emc g3phones ibm iphone legal lookup management microsoft mobile news oasis qualcomm searchdatabase smartphone software softwaredevelopment standards verizon yahoo!
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC