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!

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

A value greater or less than 0

Status
Not open for further replies.

prl423

IS-IT--Management
Feb 28, 2006
13
US
When my OTPay field indicates a value < or > than 0, and when but when there is actually an OT value, $550.00 I would like to show the PayName field to display OT....instead of regular...

the formula goes something like this:

if {tblEmpeHours.OTPay} is <> 0 then {tblEmpeHours.PayName} = "OT"

Thanks for helping....Paul
 
You're better off posting technical informtion rather than descriptions:

Crystal verison
Database/connectivity used
Example data
Expected output

You might try:
if {tblEmpeHours.OTPay} <> 0 then
"OT"

Hard to say, either there's an unusual language barrier, or you need to proofread.

-k
 
sorry, that worked and I forgot to add more syntax but I've got it now....help is greatly appreciated. Paul

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top