Finding values within a string

B

Bernman

I have 2 tables 1 that is the Master Unit to effectivity code the other is
Tasks that need to be accomplished against specific units (effectivity).

People have entered effectivity in the task table as follows
Field is "effectivity"
353-363, 365-410, 701-950
301, 410, 701-950
I need to create a list like this
Unit Effectivity original string
123 353 353-363, 365-410, 701-950
123a 354 353-363, 365-410, 701-950

456a 410 301, 410, 701-950

How can I unwind the data most effeciently?

Bernie
 
N

Nick Coe \(UK\)

Are you talking about serial number effectivity?

That is:- application of mod's or build status or change
notices to particular models of units.

If so I think I can see where you're heading but your
example data doesn't quite work out (as Karl said), or else
I'm being particularly thick this morning...

Really you have two choices (depending on version of Access)
to break a string up; You can use Split() and Join() and an
array if the string itself is in a suitable form (see the
Help) or you can parse the string with your own code. It
really hinges on what characters have been entered to
seperate (delimit) the data elements you want in the
results.

A clearer example of data would help a bit. It does look as
if you're incrementing the unit suffix alphabetically - is
that so?

--
Nick Coe (UK)
Available - Will work for money :)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store

In Bernman typed:
 
Top