943,719 Members | Top Members by Rank

Web Development > Databases > MS Access and FileMaker Pro > Expression Builder : MS ACCESS FORMS
Ad:
Permalink
Nov 26th, 2008
0

Expression Builder : MS ACCESS FORMS

Expand Post »
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
Similar Threads
Reputation Points: 18
Solved Threads: 0
Posting Whiz in Training
dinilkarun is offline Offline
206 posts
since Feb 2008
Permalink
Nov 26th, 2008
0

Re: Expression Builder : MS ACCESS FORMS

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.
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007
Permalink
Nov 27th, 2008
0

Re: Expression Builder : MS ACCESS FORMS

Its not working.Please help me with Expression builder
Reputation Points: 18
Solved Threads: 0
Posting Whiz in Training
dinilkarun is offline Offline
206 posts
since Feb 2008
Permalink
Nov 27th, 2008
0

Re: Expression Builder : MS ACCESS FORMS

Just type the following in the expression builder:

=NZ([Weight_likely],"Hello")
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007
Permalink
Dec 1st, 2008
0

Re: Expression Builder : MS ACCESS FORMS

If you can't get timothy's suggestion to work, type null rather then "" in your condition.
Reputation Points: 35
Solved Threads: 21
Junior Poster
HI2Japan is offline Offline
195 posts
since Mar 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: SQL moving data error
Next Thread in MS Access and FileMaker Pro Forum Timeline: MS Access Database





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC