concantenated expression

[Zippy]

I am using a concantenated expression in a report that contains city, state,
& zip fields. The problem is that the states are showing as lower case since
they were formated in the original field with the > sign to make them upper
case.

Is there a way to format only the state field as upper case in the
concantenated expression?

Thanks

 

[Ofer]

If they all originaly seperate fields, then before you join them change the
state to upper case

Select city & " " & Ucase(state) & " " & zip as Address From TableName

 

[Zippy]

Thanks! That worked.

Zippy

If they all originaly seperate fields, then before you join them change the
state to upper case

Select city & " " & Ucase(state) & " " & zip as Address From TableName