RSS Forums RSS

Expression Builder : MS ACCESS FORMS

Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Reply
•
•
Posts: 191
Reputation: dinilkarun is an unknown quantity at this point 
Solved Threads: 0
dinilkarun dinilkarun is offline Offline
Junior Poster

Expression Builder : MS ACCESS FORMS

  #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
AddThis Social Bookmark Button
Reply With Quote  
•
•
Posts: 240
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 22
timothybard's Avatar
timothybard timothybard is offline Offline
Posting Whiz in Training

Re: Expression Builder : MS ACCESS FORMS

  #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
Reply With Quote  
•
•
Posts: 191
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

  #3  
Nov 27th, 2008
Its not working.Please help me with Expression builder
Reply With Quote  
•
•
Posts: 240
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 22
timothybard's Avatar
timothybard timothybard is offline Offline
Posting Whiz in Training

Re: Expression Builder : MS ACCESS FORMS

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

=NZ([Weight_likely],"Hello")
http://www.timothybard.com
Reply With Quote  
•
•
Posts: 177
Reputation: HI2Japan is an unknown quantity at this point 
Solved Threads: 18
HI2Japan HI2Japan is offline Offline
Junior Poster

Re: Expression Builder : MS ACCESS FORMS

  #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  
Reply

Quick Reply to Thread
•
•
•
•

Only community members can participate in forum threads. You must register or log in to contribute.

Register


Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum
•
•
•
•
Views: 1881 | Replies: 4 | Currently Viewing: 1 (0 members and 1 guests)

 

•
•
•
•
Thread Tools Display Modes
Linear Mode Linear Mode
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 2:40 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC