Output values in reports as different

[dmaier]

I have a query which uses a cryptic value of me21 in all records for someone who has registered via the web. In a report I want to show all of the values of me21 as WEB. I think there is a way to do this but don't know how. Can anyone help?

 

[evalesthy]

If you just want to replace that one value among many you might want to look at the IIf Statement in Access Help

IIf(TestMe > 1000, "Large", "Small")

or in your case maybe

IIf([YourFieldValue] = "me21", "Web", [YourFieldValue])

you can do an Advanced Search here for IIf also. It should render some other examples.

 

[grande]

Have you tried

IIf("[TableName].[FieldName] = 'me21'", "[ReportName].[FieldName] = 'WEB'", "[ReportName].[FieldName] = [TableName].[FieldName]")

Hope this helps.

-------------------------
Just call me Captain Awesome.