Detail section questions

[Guest]

Two questions about the detail section of a report

1) Is it possible to print the detail section twice? I have a paper form that has a perforation and the detail needs to print on both top and bottom halves of the form

2) Is it possible to overlap the printing of the detail section with either a header or a footer section? I need the detail to print on the right side of the paper next to a logo graphic on the left. I can't put the logo on the left of the detail section because it would print multiple times

ctda

 

[Marshall Barton]

Two questions about the detail section of a report:

1) Is it possible to print the detail section twice? I have a paper form that has a perforation and the detail needs to print on both top and bottom halves of the form.

You might be able to arrange your data query to use in a
subreport that appears twice in the main report.

2) Is it possible to overlap the printing of the detail section with either a header or a footer section? I need the detail to print on the right side of the paper next to a logo graphic on the left. I can't put the logo on the left of the detail section because it would print multiple times!

Yes. Use the group header's Format event to prevent the
position on the page from advancing:

Me.MoveLayout = False

 

[Guest]

----- Marshall Barton wrote: ----

ctdak wrote

Two questions about the detail section of a report

You might be able to arrange your data query to use in
subreport that appears twice in the main report

2) Is it possible to overlap the printing of the detail section with either a header or a footer section? I need the detail to print on the right side of the paper next to a logo graphic on the left. I can't put the logo on the left of the detail section because it would print multiple times

Yes. Use the group header's Format event to prevent th
position on the page from advancing

Me.MoveLayout = Fals

--
Mars
MVP [MS Access


Thanks for the answers, Marsh. Much appreciated. I'll try these and see what I get
ctda

 

[Guest]

Marsh

Your help has been GREAT. I have implemented your answer to my question #2 and that did exactly what I was looking for, overlapping report sections on the printed page

I have also implemented your idea for my question #1. I created two sub-reports, each of which I placed in the detail section of my main report. (I discovered that you can’t put one sub-report into a main report twice, but that’s OK because I need the two sub-reports to be slightly different anyway.

However, to make the main report and two sub-reports work together properly, I now have to know how to do something else. Can you create a query that returns only the first occurrence of all records that have the same value in one field? e.g. Four records have value X in one field and I only want the first one of these four to be returned

ctda

----- Marshall Barton wrote: ----

ctdak wrote

Two questions about the detail section of a report

You might be able to arrange your data query to use in
subreport that appears twice in the main report

2) Is it possible to overlap the printing of the detail section with either a header or a footer section? I need the detail to print on the right side of the paper next to a logo graphic on the left. I can't put the logo on the left of the detail section because it would print multiple times

Yes. Use the group header's Format event to prevent th
position on the page from advancing

Me.MoveLayout = Fals

 

[Marshall Barton]

How you might do this depends on how you define "first
occurrence". "First" implies some kind of order to the
records that have the same value in the field. If that's
valid, then you can use a Top Values query:

SELECT TOP 1 <field list>
FROM <the table>
WHERE <one field> = X
ORDER BY <list of fields that determine "first">

If, OTOH, all the fields in the reords with X are the same,
then you can use a Distinct query:

SELECT DISTINCT <field list>
FROM <the table>
WHERE <one field> = X