Format portion of text sting in upper case

[Sammie]

I have a concatenated string in my query like
=([field1] & [field2] & [field3])
I want field2 to appear in upper case, but the rest of the fields are to be
normal case, as they were typed in. I formatted field2 in my query as upper
in the format property with ">" but the upper case is lost within my string.
Any ideas?

 

[Stuart McCall]

I have a concatenated string in my query like
=([field1] & [field2] & [field3])
I want field2 to appear in upper case, but the rest of the fields are to
be
normal case, as they were typed in. I formatted field2 in my query as
upper
in the format property with ">" but the upper case is lost within my
string.
Any ideas?

Use the Ucase function:

=([field1] & Ucase([field2]) & [field3])