Query Help, Please

[Nils Titley]

I need help with a query. I am very rusty at this but I am working on
query for the following information.
How table is set up.
ID ParentID Generation Names
1 0 1 Joe Button
2 1 2 Jim Button
3 1 2 Judy Button
4 2 3 Bill Button
5 3 3 Stacy Jones

I want to be able to query this list so that when I am done I have:
Generation Name Clarification for you
1 Joe Button (Parent)
2 Jim Button (Child of Joe)
2 Judy Button (Child of Joe)

2 Jim Buttion (Parent)
3 Bill Button (Child of Jim)

2 Judy Button (Parent)
3 Stacy Jones (Child of Judy)

Could I get some suggestions or help with this query!

Thanks for your help

 

[vbasean]

I need help with a query.  I am very rusty at this but I am working on
query for the following information.
How table is set up.
ID ParentID Generation  Names
1      0              1          Joe Button
2      1              2          Jim Button
3      1              2          Judy Button
4      2              3          Bill Button
5      3              3          Stacy Jones

I want to be able to query this list so that when I am done I have:
Generation     Name             Clarification for you
1                   Joe Button      (Parent)
2                   Jim Button      (Child of Joe)
2                   Judy Button    (Child of Joe)

2                   Jim Buttion     (Parent)
3                   Bill Button       (Child of Jim)

2                   Judy Button     (Parent)
3                   Stacy Jones     (Child of Judy)

Could I get some suggestions or help with this query!

Thanks for your help

how about a report with grouping by parent id?

 

[Nils Titley]

Ok but how do I create the sql that will give me that report? I would
appreciate a little more help.

Thanks

 

[vbasean]

Ok but how do I create the sql that will give me that report?  I would
appreciate a little more help.

Thanks






- Show quoted text -

sure.

create a report based of this table with the report wizard

when you get to the grouping option, group the report by parent id

open the report in design mode and polish it up.

that should do the trick I hope.

 

[Nils Titley]

Okay, That worked. I just have to work on getting the names of the parents
above the children.

I may list again because I am now thinking that the design of my tables are
not very normalized. So I am working on changing them.

Thanks for the help. I appreciate it.