Report

  • Thread starter Thread starter CINDY K
  • Start date Start date
C

CINDY K

I have a form with a subform set up on a tab format. My
main form is linked to a table with customer info (Name,
address etc) The sub form is a request form.

The main form will be filled out with the name address,
then the sub form will be filled out with a single
request, we can click on add another record to the subform
and add another request.

The report I have set up is to print out the requests.
Each page is a separate request. If the name has more
than one request, only one request will have the name &
address at the top, the next ones will not. I do have
a "Cust #" which identifies them, but I would rather have
the name & Address repeated. How can I do this?
 
Move your Master Record information from the Report Header or Detail section
to the Page Header section.
 
The report I have set up is to print out the requests.
Each page is a separate request. If the name has more
than one request, only one request will have the name &
address at the top, the next ones will not. I do have
a "Cust #" which identifies them, but I would rather have
the name & Address repeated. How can I do this?
Click to expand...

One way would be to use the Report's Sorting and Grouping feature to
group by name and address; put these fields in the Section Header for
that group and the request data in the Report's Detail section.

Note that the Form is completely irrelevant to the structure of the
Report - what's important for the Report is the structure of the data
in the table, not how it got into the table!
 
Back
Top