Help with Report with Loop

StuckfromPR

Registered User.
Local time
Today, 18:32
Joined
Sep 15, 2008
Messages
18
I want to put in report the results of a query, which has multiple values, and I want for each of the result have a different row. I know I have to put a Loop in the code, but I don't have and idea of how to do it. Please HELP!
 
you dont have to do anything

design an autoreport based on the query

the wizard will ask you about totalling/grouping etc, but ignore that

report has

report header
page header
group header {optional}
detail
group footer {optional}
page footer
report footer

EACH row of the query, will end up in a detail row automatically.
The overall headers footers enable you to mange the presentaiton/subtotalling/titleing etc

the wizard lets you pick which bits of the query you require to see on the report
 
But the query that is using it is in the code of a form, and the header includes some data (calculations) from that query, and I want the all the fields used in that calculations in the detail section of the report, and I don't think what you have suggested will work for me in this case.
 

Users who are viewing this thread

Back
Top Bottom