I have an Access 2000 DB for a financial company. I have the table
structure completed, but I am having trouble with the report.
Basically, I have a Client tbl, a StockShares tbl, and a StockOptions
tbl. One client can have many types of StockShares and StockOptions.
I need to detail the StockShares and StockOptions on one page. The
hierarchy should look like this:
CLIENT NAME [header section]
StockShares [StockShares header]
ABC Company [begin detail section]
DEF Company
GHI Company
JKL Company
Totals [StockShares footer]
StockOptions [StockOptions header]
MNO Company [begin detail section]
PQR Company
STU Company
VWX Company
Totals [StockOptions footer]
So, I can easily get one detail section for the StockShares, but I
cannot figure out how to get two detail sections and footers for each
on the same report. Reports seem to give me only one detail section.
What is the proper way to handle this? Should I be using Subreports in
this instance? If so, do I use one main report and one subreport, or
one main report and two subreports (one for StockShares and one for
StockOptions)?
Many thanks to anyone that can help me on this!