Access Help Required

[Da[]San]

So i have a large table with the prefix of "hpm2p-", i want to remove this so that all the numbers/text after this are produced instead - i could use Find and Replace on the original data, but would prefer a less destructive result. thanks.

 

[Malakite]

so the data has that prefix?

build a query with the following

Mid([FieldName],7,(Len([FieldName])-6))

This will give you the string that starts in position 6 in the string and lasts for the length of the field -6