Controlling records on Report

[emblic]

I have a query in my database that provides me with all the records I want on my report.

My report must:

Display all the records in certain categories(this I sorted out making use of the wizard), but I would like to limit each category to one page. The problem here is that I find difficulty in controlling the "space" access uses when throwing records together.

So at the moment I am happy in that my different categories are seperated from each other. I would just like each category to occupy one page. At the moment my report consists of 8 pages where it should only be two.

 

[IMO]

To print each record on a separate page, set the ForceNewPage property of the detail section to After Section.

IMO

 

[emblic]

Hi OMO,

I don't want to print each record on a seperate page. I want related records on one page ie I have written a database monitoring investment returns of asset managers over time. Investment Funds have different mandates or can be categorized into eg Global and Domestic. What I want is that all my records corresponding to Domestic be printed on one page and likewise for the Global Funds.

My report already groups the domestic and global records together. I just want to limit it to one page per region (1 for global, 1 for Domestic).

I really hope there is a way to do this otherwise you have a very clumsy report and you're wasting loads of paper.

 

[IMO]

OMO ?
To print each group on a separate page, set the ForceNewPage property of the group header to Before Section or the ForceNewPage property of the group footer to After Section.

IMO

 

[Rich]

I think ONO the problem here may relate to spacing as well

 

[IMO]

LOL I think you're right Tich.

IMO

 

[namliam]

OMO = washing detergant here in the netherlands

eg nice clean solution.... LOL

Regardszzzzzzzzzzzzzzzzz

 

[emblic]

Sorry IMO,

Rich is right. Say for exaple I have 60 records related to Global Funds and another 50 related to Domestic Funds. What I then want are those records 60 records for Global to be grouped on one page and the 50 for Domestic on another, totalling 2 pages.

As I have it now, the 60 is spread over about 4 pages. I have set the property to single line spacing but compared to normal word processing software this definetely is not single line spacing.

 

[Rich]

Yeah, sorry ISO,
emblic : Access uses double line spacing for some strange reason, you have to combine the fields to get single spacing.

 

[Rich]

Yeah, sorry ISO,
emblic : Access uses double line spacing for some strange reason, you have to combine the fields to get single spacing.

 

[IMO]

ISP probs Mich?

IMO

 

[Rich]

ISP probs Mich?

IMO

Arrrrrggghhh, bloody ISP

 

[emblic]

Thanks Rich,

I hope I'm not asking a realy stupid question but I need to get this done. What do you mean by combining the fields? Also where can I change the font and size for certain sections of my report.