Decode Field in Report

[theconfusedbear]

Is this possible????

I have a field in my report called LeadSource which in the table holds one letter A, B ,C and so on. Can you set an expression to say when A appears show Apple or when B appears show Bear (just as an example).

I have linked a decode table to the main data but its running from a VPN connection and it takes forever to do the match. I dont want to create a table from the VPN then have to run another query.

Just wondered ????

Thank you

 

[ColinEssex]

In the query behind the report you could use a nested IIF() function.

IIF([FieldName] = "A","Apple",IIF([FieldName] = "B", "Bear", "Coconut"))

Obviously if you have loads of different letters then a lookup table linked in the query is the way to go.

Col