Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group footers don’t play nice!

Status
Not open for further replies.

DaveMac

Technical User
Apr 9, 2000
161
US

I have a report that Footer 1 has two controls that are Min_Scrap=Min[Scrap] and Max_Scrap= Max [Scrap]. I then have some code that is Total_Scrap = [Max_Scrap] – [Min_Scrap] . Footer 2 Needs to have another Total_Scrap and Sum [Total_Scrap] .

Ideally I would like to Have something like this:

‘in the format of Footer 1 event
Min_Scrap=Min[Scrap] ‘ How do you Get text Min_Scrap to equal Min[Scrap] using VBA? I know how using the Data source on the properties
Max_Scrap= Max [Scrap] ‘ Same thing I don’t know how to set the value in VBA
Total_Scrap = [Max_Scrap] – [Min_Scrap]
End Sub

‘in the format of Footer 2 event
‘ something like this
Total_Scrap2 = the sum of all the [Total_Scrap] from Footer 1


End Sub




 
Hi,

And...... whats the prob?

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top