What's meant by 'convert'? At face value that suggests that you want to
change the data in the table permanently to upper case? Or do you merely
want to show it in upper case, while leaving the underlying values in the
original case?
For the former you'll need to run an run an 'Update' query, for the latter
you'll just need to format the columns as upper case in a query. Fred has
generously pointed you towards the UCase function for the former, and this
can also apply to the latter, though also look at how the > formatting
character is used.
You might also like to take a look at the StrConv function. One thing to
remember with this, however, is that if you use it in a query you can't use a
constant such as vbUpperCase as the conversion argument; you have to use the
actual value, in this case 1.
Ken Sheridan
Stafford, England