Print single page per entry

G

Guest

I need to know how to have the report just put a single entry information on
a sinlge page per entry but have all the information about that entry on it.
i.e. Jim smith has data entered for several different days and does Joe
Smith. I need to be able to print the inforation for both on seperate sheets.
 
F

fredg

I need to know how to have the report just put a single entry information on
a sinlge page per entry but have all the information about that entry on it.
i.e. Jim smith has data entered for several different days and does Joe
Smith. I need to be able to print the inforation for both on seperate sheets.

Group the report using the PersonID field (View + Sorting and
Grouping).
Then set the Group Header ForceNewPage property to before section.
 
G

Guest

I can do that but if you enter say "1" for the personID field it brings up
all entries with "1" in it. CAn I use the Person Name field?
 
G

Guest

Hi Tay J.,

If you continue to have problems, we may need more information about what
your data structure looks like. The reason I say this is that Access Reports
already "really want to" do exactly what you appear to be asking for. So,
first make sure that your Report's RecordSource is properly designed so that
it returns one line of data for each Person you want to include in the
printout.

Once that's the case, your Report's Detail Section should show all the data
(fields) that you want for one person (i.e. most likely just about everything
in each row that the RecordSource returns). Then, while still in Design
View, click on the Detail bar and, in the Properties window, select the
Format tab then, in the Force New Page field, select Before Section.
Anything you have in your page Header and Page Footer sections will show up
on every page.

Good luck,

Ed
 
G

Guest

We after a bit of experimentation it is working. Thanks for the help as it
was much appreciated. Here is anohter question though. When I print the
records I would like a box to show the percent difference on the time of the
participant from each of the previous to the current record. Again any help
willbe appreciated.

Thanks!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top