concantenated expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks! That worked.

Zippy

Ofer said:
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
Click to expand...
 
Back
Top