Conditional masks

[AC5FF]

Is it possible in a query alone to mask the outputs of a field?

For Example; I have a query that counts up the number of orders for a particular part. The output grabs just the first entry into a Noun field and then displays the count of orders. The problem is, the Noun is not standardized. A technician could enter "Resistor", "R15", "r15" ReSiStOr" or whatever. But I want to disply the output of my query in all caps so it is standardized.

I am pretty sure, if needed, I can go back into the table where the data is pulled from and set up an input mask there; but i don't want to mess with the table unless absolutely necessary.

Thx!

 

[Brianwarnock]

I don't know the term noun field, however to achive what you want you could use UCase(yourfield) as aliasyourfield

Brian

 

[AC5FF]

Worked like a champ!!!

Thanks!!

 

[Brianwarnock]

Replace
[AWP Top 10 Drivers Sub4].Nomenclature,

with

Ucase([AWP Top 10 Drivers Sub4].Nomenclature) as NomenclatureFLD,