SubReport

[Melinda]

I have looked through the posts and Allen Brown website concerning
subreports, but I still can't get my report to work correctly. I am trying
to carry over a grandbalance from the sub report, which is located in the
SACItem Footer into my main report. When I carry the total over into the
main report I then need to subtract it from an encumbered amount of the main
report to show how much money is left in our budget. When I preform
subtract one of the expenses it will not sum them even though the grand
balance on the sub is a sum of all expenses. Please help if you can. This
is what I put into my text box on the main report.

=[txtbudgetsum]-[subMelinda].[Report]![SacTotal]

If my txtbudgetsum amount is $34,700.00. and the expenses that were summed
were $4,700.00 and $950.00 for a total of $5650.00. It returns an answer of
$30,000.00.

thanks...
Melinda

 

[Melinda]

I might also add that I am putting the text box in the SAC footer and if I
place the text box in the Page Footer it picks up the figure for the next SAC
item throughout the entire report.

 

[vbasean]

Melinda,

Have you considered calculating the subtotal using a DSum or DLookup
function instead of trying to refer to the subform? I usually use the parent
ID to create a function outside the subform (on the main form)
--
~Your Friend Chris
http://myvbastuff.blogspot.com/
thinking out loud

I might also add that I am putting the text box in the SAC footer and if I
place the text box in the Page Footer it picks up the figure for the next SAC
item throughout the entire report.
--
Melinda

I have looked through the posts and Allen Brown website concerning
subreports, but I still can't get my report to work correctly. I am trying
to carry over a grandbalance from the sub report, which is located in the
SACItem Footer into my main report. When I carry the total over into the
main report I then need to subtract it from an encumbered amount of the main
report to show how much money is left in our budget. When I preform
subtract one of the expenses it will not sum them even though the grand
balance on the sub is a sum of all expenses. Please help if you can. This
is what I put into my text box on the main report.

=[txtbudgetsum]-[subMelinda].[Report]![SacTotal]

If my txtbudgetsum amount is $34,700.00. and the expenses that were summed
were $4,700.00 and $950.00 for a total of $5650.00. It returns an answer of
$30,000.00.

thanks...
Melinda

 

[Melinda]

Sorry, would I create a text box on the main form?

Melinda,

Have you considered calculating the subtotal using a DSum or DLookup
function instead of trying to refer to the subform? I usually use the parent
ID to create a function outside the subform (on the main form)
--
~Your Friend Chris
http://myvbastuff.blogspot.com/
thinking out loud

I might also add that I am putting the text box in the SAC footer and if I
place the text box in the Page Footer it picks up the figure for the next SAC
item throughout the entire report.
--
Melinda

I have looked through the posts and Allen Brown website concerning
subreports, but I still can't get my report to work correctly. I am trying
to carry over a grandbalance from the sub report, which is located in the
SACItem Footer into my main report. When I carry the total over into the
main report I then need to subtract it from an encumbered amount of the main
report to show how much money is left in our budget. When I preform
subtract one of the expenses it will not sum them even though the grand
balance on the sub is a sum of all expenses. Please help if you can. This
is what I put into my text box on the main report.

=[txtbudgetsum]-[subMelinda].[Report]![SacTotal]

If my txtbudgetsum amount is $34,700.00. and the expenses that were summed
were $4,700.00 and $950.00 for a total of $5650.00. It returns an answer of
$30,000.00.

thanks...
Melinda