Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Guus2005
Starting Member
10 Posts |
 Posted - 2007-05-08 : 05:36:31
|
| I have a table called Table1 with two fields: Field1: Parent and Field2: Child.I want to create a query which gives me Child, Parent, GrandParent, etc...Can i do this whithout knowing how deep this goes? |
|
|
Guus2005
Starting Member
10 Posts |
Posted - 2007-05-08 : 06:26:39
|
| This question was posted here in the Access section because searching this site i couldn't find any related question/solutionsThanks 4 your time |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-05-08 : 08:11:08
|
| Huh? For SQL you should have found dozens of threads about this.So is this an Access question or an SQL question?e4 d5 xd5 Nf6 |
|
|
|
Guus2005
Starting Member
10 Posts |
Posted - 2007-05-08 : 17:04:38
|
| I also found lots of links about this but all SQL Server related. Not Access Related. I am looking for an Access solution. That's the reasons i posted it here in the Access section. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
|
|
Guus2005
Starting Member
10 Posts |
Posted - 2007-05-09 : 01:58:10
|
| Curious...You're sending me to another forum. Why?It would be more helpfull if the supplied link would give me the answer to my question. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-05-09 : 09:27:41
|
| "You're sending me to another forum. Why?"Because not every topic can be answered here. Sometimes other forums are more EXPERT in certain areas than we are...and this is one of them...ACCESS |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-05-09 : 11:00:23
|
| Maybe if you posted your question at the supplied link, it WOULD give you an answer. That's the way it is supposed to work.e4 d5 xd5 Nf6 |
|
|
|
Guus2005
Starting Member
10 Posts |
Posted - 2007-05-11 : 02:47:42
|
| Well blindman, you're very insightfull and Mr Murphy, thanks for pointing that out to me. I will not bother you with Access questions anymore. |
|
|
|
|
|
|
Recursive Parent Child Query Question