Problems with report

[jln via AccessMonster.com]

Here is what im having a problem with.
Im have the report genrate off of a query that is going by Name, and it is
pulling all bill for each inv and grouping by investor. But the report is
place each bill on a new page and not grouping them with the inv # . I need
all the bills for each investor to be on one page.

 

[Jeff L]

Check your sorting and groupings in the design of the report. If Name
is listed first then inv #, that is one problem that you have. You
should have the data sort by inv #, then name. You will also need a
group header for Inv # and put your investor info in the header. Your
bills should then be listed in the detail section.

Hope that helps!

 

[jln via AccessMonster.com]

Thabks Jeff I was able to get it to seprate by inv with your help. But how do
i get it to create a new page when the investor number changes?

Check your sorting and groupings in the design of the report. If Name
is listed first then inv #, that is one problem that you have. You
should have the data sort by inv #, then name. You will also need a
group header for Inv # and put your investor info in the header. Your
bills should then be listed in the detail section.

Hope that helps!

Here is what im having a problem with.
Im have the report genrate off of a query that is going by Name, and it is

[quoted text clipped - 5 lines]

Message posted via AccessMonster.com

 

[Jeff L]

Put a Group Footer for inv # and look at the properties. Under the
Format tab, there is a setting called Force New Page. Change that to
After and you should get a new page.

Thabks Jeff I was able to get it to seprate by inv with your help. But how do
i get it to create a new page when the investor number changes?

Check your sorting and groupings in the design of the report. If Name
is listed first then inv #, that is one problem that you have. You
should have the data sort by inv #, then name. You will also need a
group header for Inv # and put your investor info in the header. Your
bills should then be listed in the detail section.

Hope that helps!

Here is what im having a problem with.
Im have the report genrate off of a query that is going by Name, and it is

[quoted text clipped - 5 lines]

Message posted via AccessMonster.com