By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

repeat report

P: n/a
anyone know how to create a report that will repeat itself but with
different label in the second details.

example

------------------------------------start-------------------------------------
Student's Copy

name: John Smith

Subject Descriptive Title
--------------------------------------------------------------------
Math 1 Algebra
Eng 1 Study and Thinking Skills

Accounting's Copy

name: John Smith

Subject Descriptive Title
--------------------------------------------------------------------
Math 1 Algebra
Eng 1 Study and Thinking Skills

------------------------------------end-------------------------------------

in this example i want to have an Accounting's Copy on the same page
of a report.

thanks in advance for any help.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
1. Create a table, with one text field. Mark the text field as primary key.
Save.

2. Enter 2 records into this table, containing the text:
Student's Copy
Accounting's Copy

3. Create a query containing this table and the one that has the data for
your label report. If you see any line joining the 2 tables, delete the
line: it is the lack of a join that give you a record for every combination.
Include the new table's field in the output grid. Save.

4. Open your report in design view. Change its RecordSource property to the
new query. Use the Sorting And Grouping dialog (View menu) to get the
desired order for the labels in the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jaYPee" <hi******@yahoo.com> wrote in message
news:dt********************************@4ax.com...
anyone know how to create a report that will repeat itself but with
different label in the second details.

example

------------------------------------start--------------------------------- ---- Student's Copy

name: John Smith

Subject Descriptive Title
--------------------------------------------------------------------
Math 1 Algebra
Eng 1 Study and Thinking Skills

Accounting's Copy

name: John Smith

Subject Descriptive Title
--------------------------------------------------------------------
Math 1 Algebra
Eng 1 Study and Thinking Skills

------------------------------------end----------------------------------- --
in this example i want to have an Accounting's Copy on the same page
of a report.

thanks in advance for any help.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.