force uppercase in part of expresssion

  • Thread starter Thread starter Marie
  • Start date Start date
M

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
 
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;
 
Marie said:
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
Click to expand...

Use the UCase function.

Keith.
www.keithwilby.co.uk
 
Hi Wayne, Thanks from Australia.M

Wayne-I-M said:
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.



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