Rearranging Data Format of entries in Access

  • Thread starter Thread starter tektrader78
  • Start date Start date
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
 
Back
Top