Hi
Sorry if this s stupid question or has been asked before...can't find it.
I need to write a simple formula to populate a columbn in a report.
It needs to look at 4 fields in the database and give a different value if each condition is true...
E.g.
if {Table.Field1} = "7" then "5"
else if {Table.Field2} = "7" then "6"
else if {Table.Field3} = "7" then "7"
else if {Table.Field4} = "7" then "8"
This obviosuly isn't working...
is it possible...and how!!??!!
Thanks,