Access 2003 Report

[Guest]

I have a dbs setup to track employee records. There are two tables. One
table with employees personal info and other table with time sheets. I
created a query to pull up all the employees together and a query to pull
them up by SSN. When I run the reports by specific SSN I get just one
employees record. When I pull up the whole list it puts all the employees on
one page. I want to print them all but have their info on separate pages so
I can give the record to the employee. How do I set it up to put each
employee on their own page?

 

[fredg]

I have a dbs setup to track employee records. There are two tables. One
table with employees personal info and other table with time sheets. I
created a query to pull up all the employees together and a query to pull
them up by SSN. When I run the reports by specific SSN I get just one
employees record. When I pull up the whole list it puts all the employees on
one page. I want to print them all but have their info on separate pages so
I can give the record to the employee. How do I set it up to put each
employee on their own page?

In the Report's Sorting and Grouping dialog.
In Report Design View, click on View + Sorting and Grouping.
Group on SSN.

Then, still in design view, set the SSN Group Header ForceNew Page
property to BeforeSection.
It's found on the Format tab of the GroupHeader property sheet.

The report will group on the SSN and each SSN will start on a new
page.

 

[Guest]

Thanks fredg,

That fixed one problem but created on more. I think it is a simple answer.
The name and SSN are not in a header they are in a footer. The report fills
into a form. How do I get the name, SSN and Birthday to alway show at the
bottom of the page and not directly under the information?

 

[fredg]

Thanks fredg,

That fixed one problem but created on more. I think it is a simple answer.
The name and SSN are not in a header they are in a footer. The report fills
into a form. How do I get the name, SSN and Birthday to alway show at the
bottom of the page and not directly under the information?

Did you try adding a Group Footer and putting the SSN and Name and
Birthday fields in the Group Footer?

 

[Guest]

Thanks buddy. It works perfect. I was having a massive brain fart. Now it
works perfect.