Removing characters " and = from records

M

Marty

In the query dialog paste this formula:

OutPutFieldName: Mid$([Table1]![Field1],3,Len([Table1]!
[Field1])-3)

This formula assumes that the first character you want
starts in position 3. If it is not simply change the 3
for the actual start position. The -3 assumes there are 3
unwanted characters in the string. If there is more or
less simply shange the -3 to the number of unwanted
characters.

Replace OutPutFieldName for the actual field name you
want; replace [Table1] and [Field1] for the actual table
name and field name. You may want to do a Make Table
Query.

Marty
 
Top