Report Question

[kbrad28 via AccessMonster.com]

Can anyone explain to me if it is possible to take a text field in a report
to make it simulate columns without changing the page setup options. Any help
is greatly appreciated. Thanks!

Kbrad28

 

[Marshall Barton]

Can anyone explain to me if it is possible to take a text field in a report
to make it simulate columns without changing the page setup options. Any help
is greatly appreciated. Thanks!

Normally this kind of thing is done by using a subreport for
the details. This entails creating a main report query with
only the grouping information and a subreport query with
just the detail records.

Anything beyond that is very tricky, will only work in
simple reports (e.g. no Can Grow/Shrink in the detail), and
it requires a fair amount of advanced coding.

 

[Duane Hookom]

There is a sample of creating columns without using page setup at
http://www.access.hookom.net/Samples.htm. Scroll down near the bottom of the
page.

 

[kbrad28 via AccessMonster.com]

Thanks for the sample. I am still having a hard time incorporating in my
database to do what I need.


I want to take this:
3/4 cups whole milk
3 tablespoons granulated sugar
3 cups vanilla ice cream
3/4 cup canned pumpkin (pure pumpkin)
3/4 teaspoon pumpkin pie spice

Garnish
canned whipped cream

To look like this:

3/4 cups whole milk 3/4 cup canned pumpkin (pure
pumpkin)
3 tablespoons granulated sugar 3/4 teaspoon pumpkin pie spice
3 cups vanilla ice cream GARNISH
canned whipped cream

Do you know how I can use the sample code to acquire this???

There is a sample of creating columns without using page setup at
http://www.access.hookom.net/Samples.htm. Scroll down near the bottom of the
page.
[quoted text clipped - 8 lines]

simple reports (e.g. no Can Grow/Shrink in the detail), and
it requires a fair amount of advanced coding.

 

[Duane Hookom]

My sample would only produce results that resemble across then down columns.
Your sample data and desired display suggests down then across. You could
change the sort order of your data so that my across then down would work.

Is there a good reason why you don't use page layout columns?


--
Duane Hookom
Microsoft Access MVP

Thanks for the sample. I am still having a hard time incorporating in my
database to do what I need.


I want to take this:
3/4 cups whole milk
3 tablespoons granulated sugar
3 cups vanilla ice cream
3/4 cup canned pumpkin (pure pumpkin)
3/4 teaspoon pumpkin pie spice

Garnish
canned whipped cream

To look like this:

3/4 cups whole milk 3/4 cup canned pumpkin (pure
pumpkin)
3 tablespoons granulated sugar 3/4 teaspoon pumpkin pie spice
3 cups vanilla ice cream GARNISH
canned whipped cream

Do you know how I can use the sample code to acquire this???

There is a sample of creating columns without using page setup at
http://www.access.hookom.net/Samples.htm. Scroll down near the bottom of the
page.

Can anyone explain to me if it is possible to take a text field in a report
to make it simulate columns without changing the page setup options. Any help

[quoted text clipped - 8 lines]

simple reports (e.g. no Can Grow/Shrink in the detail), and
it requires a fair amount of advanced coding.

 

[kbrad28 via AccessMonster.com]

Yes, I did try the page layout, but it changed the whole document. I just
need one particular field to look like to columns and not the whole page.

My sample would only produce results that resemble across then down columns.
Your sample data and desired display suggests down then across. You could
change the sort order of your data so that my across then down would work.

Is there a good reason why you don't use page layout columns?

Thanks for the sample. I am still having a hard time incorporating in my
database to do what I need.

[quoted text clipped - 28 lines]

 

[Duane Hookom]

You can probably use a multiple column subreport to display the details. This
might require that a level of detail get removed from the main report's
record source or the subreport get placed in a group header or footer section.
--
Duane Hookom
Microsoft Access MVP

Yes, I did try the page layout, but it changed the whole document. I just
need one particular field to look like to columns and not the whole page.

My sample would only produce results that resemble across then down columns.
Your sample data and desired display suggests down then across. You could
change the sort order of your data so that my across then down would work.

Is there a good reason why you don't use page layout columns?

Thanks for the sample. I am still having a hard time incorporating in my
database to do what I need.

[quoted text clipped - 28 lines]

simple reports (e.g. no Can Grow/Shrink in the detail), and
it requires a fair amount of advanced coding.