[AccessD] Hierachical Recursion (was: 'Heirarchal Recursion')

Thanks Gustav,  and to think I even looked up 'Heirarchal' in the
dictionary.  :-)  Do I get half credit for it being a word?

And, is it just me, or is the http://www.databaseadvisors.com site down
at the moment?

Thanks again, Ron

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, March 23, 2004 12:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Hierachical Recursion (was: 'Heirarchal
Recursion')


Hi Ron

Look up "Tree shaped reports" in the archives from Feb. 2002 for a
method running at extreme speed ...

/gustav


> I've inherited a 15MB engineering _fe A2K DB with single level product

> structures for manufactured assemblies.  I need to create an 
> 'indentured' multi-level bill of material (BOM), presumably using 
> recursion.  I used to have an article from 'Access-VB-SQL' mag some 
> time back called 'Heirarchal Recursion' (I think) but can't locate it 
> now.

> Any ideas?  Best Sources on the web?
> TIA,
> Ron Moore
> Sr. Database Administrator
> Comtech PST Corp.
> Melville, NY
> www.comtechpst.com

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com