How do I capitalize all text in a column of data in an Access Query while keeping the name of the field the same? -
how capitalize text in column of data in access query while keeping name of field same? i tried entering "spec: strconv([spec],3), error have circular argument (which, isn't surprising). how around this? is there totally different approach capitalizing in queries? given: have field named [spec]. problem: need query grab [spec] , convert caps, same field name added: call table holds field [spec], [tbltable] solution: need put in query builder following: spec: ucase([tbltable].[spec]) that way machine can figure out query.spec isn't same identifier tbltable.spec equivalently: select ucase([tblnames].[firstname]) firstname tblnames;