Skip to Content
0
Former Member
Oct 29, 2007 at 08:41 AM

Query Design - Hierarchy Question

9 Views

Hi guys,

I am making a query with Cost and Profitaccounts. All the accounts are listed up in a hierarchy.

6>61>610, 6>61>611,6>62>621 etc

Under each 3digit account we have vendor information.

Now one users wants me to create a query that only shows the 1digit accounts with directly the vendor information underneath it.

How do you do this?

Thank you,

Filip