Repeating Elements in a Report

I

Ian

I have a report based on two tables. The main is the
client info and the sub is the services. My report shows
the main client info with the services that are due that
week. The main info is in the header and the services in
the detail section of the report

I want to be able to repeat the services elements futher
down the page (so the service guys can tear it off and
bring it back to the office with the service checked
off).

The fields should be repeated 1, 2, 3 then closer to the
bottom of the page 1, 2, 3

I can't get the elements to repeat in proper order. If
I simply copy and paste the offending fields I get 1, 1,
2, 2, 3, 3. I can't find anything to get it repeat.

Help please
 
W

Wayne Morgan

One option would be to change it to a report/subreport setup. The main
client info would be in the main report and the services would be in the
subreport. Place 2 copies of the subreport on the main report, one below the
other.
 
I

Ian

Doesn't work - I've got an element in the query it's
based on that that prompts for the start and finish date -
If I repeat the report in the report it's prompts for
the dates twice. I tried putting it in an expanded
footer section but then it breaks up the "list" of query
results on to each page. Any other ideas?
 
W

Wayne Morgan

You could pop-up a form to prompt for the date before you open the report.
Once you fill in the date, click an Ok button on the form to continue and
hide the form (Visible = False). Have the query refer to the control on the
form to get the date. It may go for it twice, but you'll never know it.
Close the form when you in the Report's Close event.

Syntax in query (use in lieu of the parameter you currently have, adjust the
names to match the names you've used):
[Forms]![frmMyForm]![ctlMyControl]
 
Top