Member Avatar for dinilkarun

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

  • 3 Contributors
  • 4 Replies
  • 124 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by HI2Japan

Recommended Answers

All 4 Replies

Member Avatar for timothybard

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.

Member Avatar for dinilkarun

Its not working.Please help me with Expression builder

Member Avatar for timothybard

Just type the following in the expression builder:

=NZ([Weight_likely],"Hello")
Member Avatar for HI2Japan

If you can't get timothy's suggestion to work, type null rather then "" in your condition.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.