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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concantenate which keeps bold of some parts. 5
concantenate help please 3
Concantenate Text Fields in a Report Control 2
Auto concantenate 1
Stuck on Padding 3
Recognize text as numeric 6
Textbox Error 3
Using OpenArgs in a Report 5

Back
Top