Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

negative value to show zero 1

Status
Not open for further replies.
rowan1

rowan1

Technical User
Mar 26, 2002
24
0
0
ES
I have a calculated control on my report.The next control multiplies the previous control by 20%. If the value of the first control is negative I want it to return Zero. Can someone show me how to do this?

Thanks
 
Sort by date Sort by votes
Set the controlsource to:

=Iif(FormControlname<0,0,FormControlname)

replacing "Formcontrolname" with the name of the form control from its property box.

John
 
Upvote 0 Downvote
Thanks John worked perfectly.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Show Previous Year 1
Replies
5
Views
93
dhookom
dhookom
PLCBeetle
  • Locked
  • Question
Pass Form value to Report Record Source
Replies
4
Views
63
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
106
dhookom
dhookom
iamchemist
  • Locked
  • Question
Push To WORD?
Replies
3
Views
98
iamchemist
iamchemist
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
263
EwaFAMA
EwaFAMA

Part and Inventory Search

Sponsor

Back
Top