Removing unwanted characters in field

[Alex]

Hi

i have a field for which I want to remove the first three and 6th character.
How would i go about this please - I assume I need to run two queries?

Thanks
A

 

[David F Cox]

something like:

newfield: MID([oldfield],4,2) & MID([oldfield],7)

This is assuming that [oldfield] is present in the expected format

see VB help on MID. Press Alt + F11 to get into VB, and enter Help there.

 

[Alex]

Thanks David

A

something like:

newfield: MID([oldfield],4,2) & MID([oldfield],7)

This is assuming that [oldfield] is present in the expected format

see VB help on MID. Press Alt + F11 to get into VB, and enter Help there.

Hi

i have a field for which I want to remove the first three and 6th
character. How would i go about this please - I assume I need to run two
queries?

Thanks
A