Force Page break

[alfred67]

Hello

I would like to Thank everyone who are help me. You guys are great

I'm trying to force a page break per group , everything I try gives me one item per page .

I have a list of number items (example 100,101,102...201,202 etc)

I need a different page for the 100's, 200's, 300's etc

I'm using access 2003

Thanks

Alfred67

 

[vbaInet]

Hello

I would like to Thank everyone who are help me. You guys are great

I'm trying to force a page break per group , everything I try gives me one item per page .

I have a list of number items (example 100,101,102...201,202 etc)

I need a different page for the 100's, 200's, 300's etc

I'm using access 2003

Thanks

Alfred67

Grouping & Sorting, when you create a grouping for the ItemNumbers it creates a Header. Click the Header and change the Force New Page property to "Before Section"

 

[stopher]

Grouping & Sorting, when you create a grouping for the ItemNumbers it creates a Header. Click the Header and change the Force New Page property to "Before Section"

Adding to what vbaInet has said, I suspect you are not knowing what to group on. I think you maybe need to create a new field in your underlying query called say Group100. This can then be a calculated field along the lines of:

Group100: Cint(ItemNo/100)*100 (summing ItemNo is numeric)

Group100 can then be used as the grouping that vbaInet talks about.

hth
Chris

 

[alfred67]

This worked like a charm but for some reason it seems to be rounding. Example item numbers 160,170,180 etc it puts with the 200 group. Any ideas how to fix this ??

Alfred67

 

[alfred67]

I got it .I replaced Cint with fix and it worked

Thank you stopher and vbainet for all your help

Alfred67

 

[vbaInet]

I got it .I replaced Cint with fix and it worked

Thank you stopher and vbainet for all your help

Alfred67

You're welcome.

 

[stopher]

I got it .I replaced Cint with fix and it worked

Thank you stopher and vbainet for all your help

Alfred67

Oops, my mistake I do have a habit of using CINT instead of INT. But as you've already found, FIX will do the job nicely.

Glad you've got it sorted.

Chris

 

[vbaInet]

Oops, my mistake I do have a habit of using CINT instead of INT. But as you've already found, FIX will do the job nicely.

Glad you've got it sorted.

Chris

Stopher, I didn't even know Fix existed haha! Cheers