How do I capitalize all text in a column of data in an Access Query while keeping the name of the field the same?

Question

I tried entering "SPEC: StrConv([SPEC],3), but I get an error that I have a circular argument (which, isn't too surprising). So how do I get around this?

Is there a totally different approach to capitalizing in queries?

score 2 · Accepted Answer · answered Jul 21 '15 at 21:52

Given: we have a field named [SPEC].
Problem: need query to grab [SPEC] and convert it to all caps, but with the same field name
Added: We will call the table that holds the field [SPEC], [tblTable]

Solution: What we need to put in the query builder is the following:

SPEC: UCase([tblTable].[SPEC])

That way the machine can figure out that Query.SPEC isn't the same identifier as tblTable.SPEC

Equivalently:

SELECT UCase([tblNames].[FirstName]) AS FirstName
FROM tblNames;

Thanks! I figured it was something simple. – theforestecologist Jul 21 '15 at 22:01 — theforestecologist, Jul 21 '15 at 22:01

score 0 · Answer 2 · answered Jul 21 '15 at 19:13

0

How about using the Ucase function

Ucase(String)

answered Jul 21 '15 at 19:13

John

974
8
16

I think there is a problem with your vision....check the "accepted" answer and also my answer....the only issue with my answer is that the poster lacks any knowledge and needs a step by step guide to use an Access function.... – John Jul 22 '15 at 08:45

How do I capitalize all text in a column of data in an Access Query while keeping the name of the field the same?

2 Answers2