Access 2007

T

Tom Wickerath

Hi Ron,

Run an Update query that includes the UCase function. Start by creating a
normal Select query that returns the appropriate records. Then convert the
query to an Update query. In the Update To row, enter: UCase([FieldName]),
where fieldname is the name of your field. Run the Update query.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top