David Mack
Registered User.
- Local time
- Today, 13:20
- Joined
- Jan 4, 2000
- Messages
- 53
I have a module which produces staistical data which is then fed to a detailed report. I currently use a form filter on which a user selects custom criteria for their reports. Our upper management likes to have a report which shows the statistics for every unit, which is a total of as many as 15 reports, without having to enter each unit's criteria one at a time on the form filter.
What I would like to do is have the the contents of the Unit table passed into my SQL statement in the module one record at a time until EOF with a statistical report produced for each unit.
Basically, how do I pass the contents of the Unit table to a loop in my module one record at a time?
Thank you,
Dave
What I would like to do is have the the contents of the Unit table passed into my SQL statement in the module one record at a time until EOF with a statistical report produced for each unit.
Basically, how do I pass the contents of the Unit table to a loop in my module one record at a time?
Thank you,
Dave