gettting some info out of group of information

  • 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.
 
Suzanne,

Assuming there are always 7 characters before the B/L part and 8 after it
(including the spaces), you can extract the B/L part from the Property field
by means of:

Mid([Property], 8 ,Len([Property]) - 15)

You can use this expression in the Update To line in the design grid of an
update query, to populate the new field in your table.

HTH,
Nikos
 
Back
Top