data manipulation

[Jasmine]

I have a field called file number which is in number
format. The data is a 6-digit number. For example 123456

I need to somehow develop a query/report that will show
the above number as 456123.

I know it sounds crazy, really it is, but nonetheless,
that is how we file things here.

Thanks,
Jas

 

[Michel Walsh]

Hi,



1000*( x MOD 1000 ) + x\1000




Hoping it may help,
Vanderghast, Access MVP