Fill in the gaps...

[YouWontSpamThisAdress]

Hi,

I have a interval database that I need to fill in the blanks when there is
one... here I explain :

What I have :

For instance :

0 to 100 = Grass
20 to 21 = sand
35 to 50 = Water

I need to endup with :

1 to 20 Grass
20 to 21 Grass + Sand
32 to 35 Grass
35 to 50 Grass + water
50 to 100 Grass...

does someone here knows of some kind of control, third party software that
would do that...

I have no idea how to code this.

Thanks.

[John W. Vinson]

How is your table actually structured? Do you have a text field with the
string "1 to 20", or a Number field, or what? How many different categories
might a number be in: grass, sand, rock, savannah, marsh, forest, ice...? What
do you want if the number isn't in any defined?

More info please! I'm sure a Query or at worst some pretty simple VBA code can
give you this, but it's still a bit unclear what you're starting with!
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

[YouWontSpamThisAdress]

The From and to are in seperate numeric fields.

I've written grass. sand and water, but the actual data is rock names
(anyways the name isn't important here).

Here is an example of the actual database:

HOLE_NUMBER Depth_From Depth_To INTERVAL_ID Alteration
118-02-02B 528.2 604.1 45198 TC+
118-02-02B 529.4 534.2 45198 BO+
118-02-02B 529.4 534.2 45198 TC+
118-02-02B 544.8 545.7 45198 SI+
118-02-02B 601.4 604.1 45198 CL+
118-02-02B 601.4 604.1 45198 BO+

this is the actual database, it need to be translate to another software
that doesn't support "overlap".

Interval 528.2 to 604.1 includes 2 different intervals...

The resulting table I want is :

HOLE_NUMBER Depth_From Depth_To New To INTERVAL_ID Alteration New
Alt:
118-02-02B 528.2 604.1 529.4 45198 TC+
118-02-02B 529.4 534.2 45198 BO+ TC+; BO+
118-02-02B 529.4 534.2 45198 TC+ Forget this one, since it's the
same as the "mother" interval
Inserted 118-02-02B 534.2 544.8 TC+
118-02-02B 544.8 545.7 45198 SI+ TC+; SI+
Inserted 118-02-02B 545.7 601.4 TC+
118-02-02B 601.4 604.1 45198 CL+ TC+; CL+; BO+
118-02-02B 601.4 604.1 45198 BO+

"John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> a écrit dans le
message de news: 2n8436d3vpu2quie2...@4ax.com...

[John W. Vinson]

On Mon, 5 Jul 2010 15:04:00 -0400, "YouWontSpamThisAdress"
<JustTryThi...@FuckinSpammers.com> wrote:

>
>Here is an example of the actual database:
>
> HOLE_NUMBER Depth_From Depth_To INTERVAL_ID Alteration
> 118-02-02B 528.2 604.1 45198 TC+
> 118-02-02B 529.4 534.2 45198 BO+
> 118-02-02B 529.4 534.2 45198 TC+
> 118-02-02B 544.8 545.7 45198 SI+
> 118-02-02B 601.4 604.1 45198 CL+
> 118-02-02B 601.4 604.1 45198 BO+
>
>
>
>this is the actual database, it need to be translate to another software
>that doesn't support "overlap".
>
>Interval 528.2 to 604.1 includes 2 different intervals...

I suspect you'll need some VBA code since there is evidently an arbitrary
number of values for each interval. Take a look at the code at
http://www.mvps.org/access/modules/mdl0004.htm to see if it can be used to
build up your string of Alteration values.

[YouWontSpamThisAdress]

Hi John,

Unfortunately it doesn't help, but the idea to create a function is a good
idea.
... I'll give it a try.

Thanks

"John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> a �crit dans le
message de news: 95o436p42ud6995g2...@4ax.com...