Grouping Problem

[dee]

Hi,

I am creating a report based on a query that contains an employee name,
employee number, address, etc., plus the names of the employee dependents.

If I create a simple report using the wizard that groups by employee number,
it seems to group the dependents fine. However, when I start to design the
form the way I need to, it no longer seems to work.

This is what I need to see:

Page 1 of report:

Employee First
Employee Last
Employee Number

Some text here that is copied and pasted from a Word document.

Page 2 of report:
Employee First
Employee Last
Employee Number

Some text that is copied and pasted from a Word document.

**Now I need a "list" of the employee dependents, for example:**
Dependent1 First Dependent1 Last Dependent1 DOB
Dependent2 First Dependent2 Last Dependent2 DOB

etc.

However, what I end up with is a separate page for each dependent, instead
of a list.

What am I doing wrong?

I will need the same list later on in another page of the report, BTW.

Any help will be GREATLY appreciated!

 

[Marshall Barton]

I am creating a report based on a query that contains an employee name,
employee number, address, etc., plus the names of the employee dependents.

If I create a simple report using the wizard that groups by employee number,
it seems to group the dependents fine. However, when I start to design the
form the way I need to, it no longer seems to work.

This is what I need to see:

Page 1 of report:

Employee First
Employee Last
Employee Number

Some text here that is copied and pasted from a Word document.

Page 2 of report:
Employee First
Employee Last
Employee Number

Some text that is copied and pasted from a Word document.

**Now I need a "list" of the employee dependents, for example:**
Dependent1 First Dependent1 Last Dependent1 DOB
Dependent2 First Dependent2 Last Dependent2 DOB

etc.

However, what I end up with is a separate page for each dependent, instead
of a list.

What am I doing wrong?

I will need the same list later on in another page of the report, BTW.

It sounds like you have the detail section's ForceNewPage
property set. If so, change it back to None and set the
group header section's ForceNewPage to Beore Section.

 

[dee]

Hi and thanks so much for your response.

I had the first parameter set to None already, but changed the Force New
Page to Before Section, however, I'm still encountering the same problem.

It seems to occur as soon as I insert the text frames from my Word document
that need to be incorporated in my report. It's a multi page report and the
employee and dependent data needs to be repeated a few times within these
pages. What happens is that instead of being able to list all dependents one
after the other between text frames on the various pages, it seems to repeat
the same page over and over for each dependent, one at a time.

I have inserted manual page breaks where I wish the pages to break - could
this be causing a problem?

Thanks!

 

[Marshall Barton]

I had the first parameter set to None already, but changed the Force New
Page to Before Section, however, I'm still encountering the same problem.

It seems to occur as soon as I insert the text frames from my Word document
that need to be incorporated in my report. It's a multi page report and the
employee and dependent data needs to be repeated a few times within these
pages. What happens is that instead of being able to list all dependents one
after the other between text frames on the various pages, it seems to repeat
the same page over and over for each dependent, one at a time.

I have inserted manual page breaks where I wish the pages to break - could
this be causing a problem?

I don't know where you put the PageBreak controls, but they
could be causing the problem. If the entire detail section
is supposed to be on a single page, then I don't see why any
PageBreak controls should be used.

It sounds like the stuff from Word could very well be part
of the problem too, but I have no idea what that stuff is.
You said you "insert the text frames from my Word document",
but I neither understand what that means nor do I have any
experience doing that kind of thing so anything I said about
it would be meaningless.

As far as Access generating page breaks, check each
section's ForceNewPage and KeepTogether properties to make
sure they are set appropriately. Also double check that the
report's width fits within the margins and that there is no
excess unused space at the bottom of the detail section.

 

[dee]

Thanks for the reply.

I basically just copy and paste sections of an already existing Word
document into the report.

I'm not sure if I should be using another approach.

 

[dee]

This may post twice, as I had an error the first time.

Basically, I am copying and pasting text from an already existing Word file
into the report. I'm not sure if this is what is causing the problem.

 

[Marshall Barton]

I basically just copy and paste sections of an already existing Word
document into the report.

I'm not sure if I should be using another approach.

As I said before, I am not qualified to comment on that.

Did you check all the Access things I think might cause your
problem?