[RESOLVED] Help With Formula Field

[Besoup]

Why not use 2 fields? just line them up ontop of each other.

[melvin74]

Why not use 2 fields? just line them up ontop of each other.

And that is an option. However, how do i suppress one field if the other is blank.

If the location field in the db i blank i dont want it to say Location: above it.

[Besoup]

if {LabHist.LOCATION} = "" then
""
else
"LOCATION:"

can try that in a formula field... I didn't test it tho.

[melvin74]

if {LabHist.LOCATION} = "" then
""
else
"LOCATION:"

can try that in a formula field... I didn't test it tho.

Actually i think i got it. You can format the field and off of suppress i was able to put a function.

thanks