Force new Column in Report??

[Mal]

Hello..

Is there a property to force a new column in a report.

I've looked at moveLayout, newRecord...and am thinking that some
combination of those might do it...but how???

I want to test for a condition (IF...then)
and force a new column if its true.

ideas??

Mal.

[Salad]

Mal wrote:

Hello..

Is there a property to force a new column in a report.

I've looked at moveLayout, newRecord...and am thinking that some
combination of those might do it...but how???

I want to test for a condition (IF...then)
and force a new column if its true.

ideas??

Mal.

Yes. You need to create a grouping first. From the menu select
View/Sorting & Grouping. Let's say you have a report with a sort group
of Code and Name. Codes are A-Z. You want a new column started with
the code changes. Create a footer for Code. Dbl-Click on the footer
band. Select New Row or Column from the property sheet.

[Mal Reeve]

Actually, I'm not testing against the data.
Can I test for how many lines have been printed on the page and then push a
new column.
ie. After 6 lines a new column
or after 8 lines etc.

Mal.
"Salad" <oi*@vinegar.com> wrote in message
news:hz***************@newsread1.news.pas.earthlin k.net...

Mal wrote:

Hello..

Is there a property to force a new column in a report.

I've looked at moveLayout, newRecord...and am thinking that some
combination of those might do it...but how???

I want to test for a condition (IF...then)
and force a new column if its true.

ideas??

Mal.

Yes. You need to create a grouping first. From the menu select
View/Sorting & Grouping. Let's say you have a report with a sort group
of Code and Name. Codes are A-Z. You want a new column started with
the code changes. Create a footer for Code. Dbl-Click on the footer
band. Select New Row or Column from the property sheet.

[Salad]

Mal Reeve wrote:

Actually, I'm not testing against the data.
Can I test for how many lines have been printed on the page and then push a
new column.
ie. After 6 lines a new column
or after 8 lines etc.

Mal.
"Salad" <oi*@vinegar.com> wrote in message
news:hz***************@newsread1.news.pas.earthlin k.net...

Mal wrote:

Hello..

Is there a property to force a new column in a report.

I've looked at moveLayout, newRecord...and am thinking that some
combination of those might do it...but how???

I want to test for a condition (IF...then)
and force a new column if its true.

ideas??

Mal.

Yes. You need to create a grouping first. From the menu select
View/Sorting & Grouping. Let's say you have a report with a sort group
of Code and Name. Codes are A-Z. You want a new column started with
the code changes. Create a footer for Code. Dbl-Click on the footer
band. Select New Row or Column from the property sheet.

I would check out http://groups.google.com
I would check out http://support.microsoft.com

Maybe you'll find some solutions there.

Perhaps you can use the Label wizard instead.

Personally, I'd see if I could figure out a way to set up a grouping in
the query and let the program operate normally.