G
Guest
I haven't been able to find a way to subtotal a group correctly in a report.
My report is using a query that has two tables joined. First table is a
Stock Type Table and the second table is a Transaction Table.
The first table has the original # of shares and the second table has the
number of shares sold on a specific date.
I have four headers in the report. The first header stock type is the one I
want a subtotal on. I want to be able to subtotal the original # of shares
purchased from the First Table and put it in the First Footer. I need to
make sure that if I have several transactions in table 2 it doesn't add the
original shares several times but just once.
Thanks
My report is using a query that has two tables joined. First table is a
Stock Type Table and the second table is a Transaction Table.
The first table has the original # of shares and the second table has the
number of shares sold on a specific date.
I have four headers in the report. The first header stock type is the one I
want a subtotal on. I want to be able to subtotal the original # of shares
purchased from the First Table and put it in the First Footer. I need to
make sure that if I have several transactions in table 2 it doesn't add the
original shares several times but just once.
Thanks