poaching data

  • Thread starter Thread starter suzanne
  • Start date Start date
S

suzanne

Using access 2000. Non programmer. Syntax wanted. Field
called property has bunch of information. Within field
are words: B/L#. 352/53 Referee.

The numbers 352/42 are constantly changing for each
record, i.e. 42/2456, 123/56789, etc. I have create
separate field called B/L.

I want to run update field in query to poach the numbers
after b/l#. and before Referee and put them into B/L field.

Suggestions as to appopriate syntax would be appreciated.
 
Hi Suzanne,

Assuming that all records are written in his same sintax, beginnig with
"B/L#. " and finishing with " Referee" , you could create a query and use
the SQL:

UPDATE YourTable SET [B/L] = Mid([property],7,Len([property])-14);

Change: YourTable by the name of your table

Take care
Mauricio Silva
 
Back
Top