Hi,

can anyone tell me how to remove the first character of a field when viewing data in a querry.

ie

original data- V00366L2336
new data - 00366L2336

right([YourData],len([YourData]-)

Just tried it and does not seem to work perhaps you could tell me the complete syntax.

the field of the original data is PartNumber and the data is in different lenghts
the new field needs to be called new

thanks

In the QBE field:

NewName:Right([YourData],len([YourData])-1)

I apologize for the typo.