J
James Tully via AccessMonster.com
I am trying to create a report with following structure.
The parent report is drives three sub reports. The parent is group by
organization. Each organization may send out 1 or more solicitations for
contract work (first sub report is solicitations). Each solicitation may
result in one or more contracts (second sub report is contracts). Each
contract may have one or more task orders (third sub report is task orders)
.. My users want the report to show each organization follow by all their
solicitations, follow by all their contracts, and finally all their task
orders. The data is organized in a tree like structure. I have been
trying this with Access 2000 for a week now. I get all the data to come
out OK but not in the right order. Access wants in the tree structure ?
solicitation, contract, task order - solicitation, contract, task order ?
etc.
Any ideas?
The parent report is drives three sub reports. The parent is group by
organization. Each organization may send out 1 or more solicitations for
contract work (first sub report is solicitations). Each solicitation may
result in one or more contracts (second sub report is contracts). Each
contract may have one or more task orders (third sub report is task orders)
.. My users want the report to show each organization follow by all their
solicitations, follow by all their contracts, and finally all their task
orders. The data is organized in a tree like structure. I have been
trying this with Access 2000 for a week now. I get all the data to come
out OK but not in the right order. Access wants in the tree structure ?
solicitation, contract, task order - solicitation, contract, task order ?
etc.
Any ideas?