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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update a field from 1 through 10 6
Pull info from one table to make many 1
Include first 3 characters in results 5
Strip leading characters from field name 16
Get record I just appended to a table? 3
recursively retrieve records from 2nd table based on records from 1
replace characters in table 6
export vba not working 0

Top