Performing Loop query ( for parts replaced)

[Guest]

Hello:

I'm wondering if there is a way to build a query that will repeat itself
based on the its own results.

Here is what I mean:

{Related fields in my table are "PartNumber" and "SupersededBy". If the
PartNumber is not replaced by another part, the field displays "N/A".}

My parameter query should prompt user to enter a "PartNumber". Let's say
"part1" is entered. Assuming that "part 1" is superseded (recplaced) by
"part2", I would like the fields of the first row to contain:

PartNumber="part1", SupersededBy="Part2"

(Simple enough....Here's what I can't figure out

If "part2" has also been superseded, I want the second row of the query
results to return:

PartNumber=part2, SupersededBy=part3

Until say:

PartNumber=part3, SupersededBy="N/A"

At this point is where the query result should stop. So for my example
the query would return 3 records, with fields: PartNumber (and) SupersededBy.

Can something like this be done? Please say yes, please!

Thank you!

--Gabriel

 

[Guest]

This ain't the complete as it returns more than you want. Maybe you can work
on it somemore.
Mercadogs_1 ---
SELECT Mercadogs.PartNumber, Mercadogs.SupersededBy
FROM Mercadogs
WHERE (((Mercadogs.SupersededBy) Is Not Null));

SELECT Mercadogs.PartNumber, Mercadogs.SupersededBy, Mercadogs.Etc
FROM Mercadogs, Mercadogs_1
WHERE (((Mercadogs.PartNumber)=[Enter part number])) OR
(((Mercadogs.PartNumber)=[Mercadogs_1].[SupersededBy]))
GROUP BY Mercadogs.PartNumber, Mercadogs.SupersededBy, Mercadogs.Etc;

 

[Guest]

Thanks a lot Karl! I will try this to see how it goes!

This ain't the complete as it returns more than you want. Maybe you can work
on it somemore.
Mercadogs_1 ---
SELECT Mercadogs.PartNumber, Mercadogs.SupersededBy
FROM Mercadogs
WHERE (((Mercadogs.SupersededBy) Is Not Null));

SELECT Mercadogs.PartNumber, Mercadogs.SupersededBy, Mercadogs.Etc
FROM Mercadogs, Mercadogs_1
WHERE (((Mercadogs.PartNumber)=[Enter part number])) OR
(((Mercadogs.PartNumber)=[Mercadogs_1].[SupersededBy]))
GROUP BY Mercadogs.PartNumber, Mercadogs.SupersededBy, Mercadogs.Etc;

--
KARL DEWEY
Build a little - Test a little

Hello:

I'm wondering if there is a way to build a query that will repeat itself
based on the its own results.

Here is what I mean:

{Related fields in my table are "PartNumber" and "SupersededBy". If the
PartNumber is not replaced by another part, the field displays "N/A".}

My parameter query should prompt user to enter a "PartNumber". Let's say
"part1" is entered. Assuming that "part 1" is superseded (recplaced) by
"part2", I would like the fields of the first row to contain:

PartNumber="part1", SupersededBy="Part2"

(Simple enough....Here's what I can't figure out

If "part2" has also been superseded, I want the second row of the query
results to return:

PartNumber=part2, SupersededBy=part3

Until say:

PartNumber=part3, SupersededBy="N/A"

At this point is where the query result should stop. So for my example
the query would return 3 records, with fields: PartNumber (and) SupersededBy.

Can something like this be done? Please say yes, please!

Thank you!

--Gabriel