force uppercase in part of expresssion

[Marie]

I want to combine fields first name and last name, but I want Last name in
upper case. The last name field in the table is forced to upper case with
">", but that does not work in the expression (well I can't get if to work.
Probably a super simple question, but thanks.
M

 

[Wayne-I-M]

Hi Marie

Use
CorrectedName: [TableName]![1stName] & " " & UCase([TableName]![2ndName])


or the sql would look something like
SELECT [TableName]![1stName] & " " & UCase([TableName]![2ndName]) AS
CorrectedName
FROM TableName;

 

[Keith Wilby]

I want to combine fields first name and last name, but I want Last name in
upper case. The last name field in the table is forced to upper case with
">", but that does not work in the expression (well I can't get if to
work.
Probably a super simple question, but thanks.
M

Use the UCase function.

Keith.
www.keithwilby.co.uk

 

[Marie]

Hi Wayne, Thanks from Australia.M

Hi Marie

Use
CorrectedName: [TableName]![1stName] & " " & UCase([TableName]![2ndName])


or the sql would look something like
SELECT [TableName]![1stName] & " " & UCase([TableName]![2ndName]) AS
CorrectedName
FROM TableName;


--
Wayne
Manchester, England.

I want to combine fields first name and last name, but I want Last name in
upper case. The last name field in the table is forced to upper case with
">", but that does not work in the expression (well I can't get if to work.
Probably a super simple question, but thanks.
M