Rearranging Data Format of entries in Access

T

tektrader78

Hi everyonne
New to the update query use in access. I would like to get links of
resources on using update query on exisiting data.
Particularly rearranging the format of entries in a table.
For starters how do i rearrange a field that has numbers in this
format 123456E
and make it E123456
I know i have to use the following strings left, mid and right but
dont know where to start in using it and applying it to my problem

Thanks in advance,
D. Atanu
 

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