Deleting surplus dashes and suffix's

  • Thread starter Thread starter Susan from Florida
  • Start date Start date
S

Susan from Florida

Field proj3 has many entries as follows:
03-25345-es
04-81856

On those entries in which a dash and initals appear, I
want to run an update query to remove them. I don't know
SQL and visual basic. The table is called project.

Sample language which I can copy and paste into the query
would be appreciated.
 
Susan,
Do you always have the dash and initials in the same
place? If so, you should be able to get the results you
want with the following:

newfld:MID([yourfld],1,8)

This just takes your field, starts at position 1 and
selects 8 positions of data.

Hope this helps.
 
Back
Top