Pedigree query too complex

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HLarkin - 08 Feb 2008 15:25 GMT

I am want to build a 4 or 5 generation pedigee with access. I used the
www.allenbrowne.com method (used dog's instead of horses)

I am getting a Query Too Complex message box. If I use 3 generations it's
ok but is there a way I can build 5 or more pedigree generation I get the
message.

Any ideas?

Thanks

Reply to this Message

Michel Walsh - 08 Feb 2008 15:50 GMT

You may have a problem of matching parenthesis.

You cannot have more than 32 tables, neither more than 50 levels of nesting
(Access 2003).

Vanderghast, Access MVP

>I am want to build a 4 or 5 generation pedigee with access. I used the
> www.allenbrowne.com method (used dog's instead of horses)
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

HLarkin - 08 Feb 2008 16:43 GMT

Do I need to create another query based on the origonal 3 generation query to
create a 4 or 5 generation pedigree?

My ultimate goal is to create a report that shows 5 generations for any dog
selected?

Thanks for your help

> You may have a problem of matching parenthesis.
>
> You cannot have more than 32 tables, neither more than 50 levels of nesting
> (Access 2003).
>
> Vanderghast, Access MVP

Reply to this Message

Michel Walsh - 08 Feb 2008 20:08 GMT

Not necessary, but try from the graphical interface, if possible. If not,
try the following pattern, for the FROM clause:

FROM (((table1 AS a LEFT JOIN table1 AS b
ON a.child = b.parent)
LEFT JOIN table1 AS c
ON b.child = c.parent)
LEFT JOIN table1 AS d
ON c.child = d.parent)
LEFT JOIN table1 AS e
ON d.child = e.parent

where the use of parenthesis can be very important, with Jet.

Hoping it may help,
Vanderghast, Access MVP

> Do I need to create another query based on the origonal 3 generation query
> to
[quoted text clipped - 13 lines]
>>
>> Vanderghast, Access MVP

Reply to this Message