Access 2007

  • Thread starter Thread starter Ron
  • Start date Start date
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/
__________________________________________
 
Back
Top