Hiding a Detail band but using Detail formula in grouping

[RowenaB]

Hi,

I am not to clued up on Access but am writing a small App with a whole lot of reports - I have the following issue and would appreciate any help.

I have created a report and in the Detail band I have created a formula to determine the age of an amount - I then want the total of this to appear in the Group footer.

Formula in Detail Band - SumAmt is a public variable

If DateDiff("d", Costdate1, Now) > 15 Then
Let Report_CardholderSummary.Over30days = Report_CardholderSummary.pcamt
Let SumAmt = SumAmt + Report_CardholderSummary.pcamt
Else
Let Report_CardholderSummary.Over30days = 0
End If


Formula in Group band

Let Report_CardholderSummary.Tot30days = SumAmt


If I run the report with the Details band visible it works but I want to hide the details band. As soon as I do this the formula no longer works and I get a 0 for the SumAmt in the Grouping Footer.

I have no idea where to go from here - I have tried changing the Height but that does not seem to work.

Any ideas would be greatly appreciated.

Thanks
Rowena

 

[randysmid]

Hi,
I would try hiding (Visible = No) ALL the items in the detail band, then minimize the detail band area.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association