G
Guest
My report looks like this:
(main report)
1st month Purchased 2nd month Purchased 3rd month Purchased
20 30 50
---------------------------------------------------------------------------------
(subreport)
5 sales 4 sales
8 sales
---------------------------------------------------------------------------------
13 total 4 total
(main report)
7 left 30 left 46 left
Grand total: 83 available to sell
I cannot get it to give me the #83 in the report footer. I am trying to
have it sum the 7, 30, and 46 which are totals from the subreport minus the
amount purchased. I have tried putting in the whole reference to the
subreport total, however it only gives me the first column of information.
As soon as I put "sum" in it, it doesn't work. I do have this report set up
as a 6 column layout. Any ideas? Thanks so much!!
at
(main report)
1st month Purchased 2nd month Purchased 3rd month Purchased
20 30 50
---------------------------------------------------------------------------------
(subreport)
5 sales 4 sales
8 sales
---------------------------------------------------------------------------------
13 total 4 total
(main report)
7 left 30 left 46 left
Grand total: 83 available to sell
I cannot get it to give me the #83 in the report footer. I am trying to
have it sum the 7, 30, and 46 which are totals from the subreport minus the
amount purchased. I have tried putting in the whole reference to the
subreport total, however it only gives me the first column of information.
As soon as I put "sum" in it, it doesn't work. I do have this report set up
as a 6 column layout. Any ideas? Thanks so much!!
at