Repeating Information

[jyoung729]

Is there a way to have a field(s) only appear once on a page with multiple
columns? It seems silly to have it repeat the information that is constant
again in the next column. I just need the variable information to be in the
next column.

For example, the listing of sizes are the constant and only need to be
listed once on the left side of the page and the pricing for the different
items listed in each column to the right of the sizes.

 

[Steve]

It can be done by creating a crosstab query where size is the row, item is
the column and price is the value. You would then create a crosstab report
using the query as the recordsource. Look at crosstab query in the Help
file.

Steve
(e-mail address removed)

 

[KARL DEWEY]

I do not think a crosstab query will do it for jyoung729 but changing the
report field property Hide Duplicates to Yes will.

 

[jyoung729]

Hide duplicates does not work. Each item has five different sizes, with no
duplicates. The whole group of sizes is showing up multiple times on the page
with each item. I only want it to appear once along the left margin and not
repeat in the next column with the next item and it's pricing.

 

[jyoung729]

This didn't quite work either. There are too many items. I need to have the
item be a populated field in the report, not an individual field, so it will
wrap to the next page on it's own. And overall, there are a lot of different
sizes. However, most items only come in about 5 sizes. This way listed out
all possible sizes for all items which is also unnecessary.

 

[KARL DEWEY]

I am not following you as I thought you want something like this --
Item Size Price
Beer Keg $15.29
Case $3.47
Can $1.29
Btl $1.13
Popcorn Case $5.49
Box $2.38
Pack $.97
Bag $.35
where the item is not duplicated.

 

[KenSheridan via AccessMonster.com]

Group the report on each of the columns with the repeating values, so of
there are three columns you'll have three group levels. Give the lowest of
these group levels a group header and put the controls bound to the three
columns in the left part of this header. In the right part of the detail
section out the controls bound to the columns with the variable values. Make
sure the controls are in each case of the same depth contiguous with the top
of the header and detail sections respectively.

Set the group header's RepeatSection property to True (Yes). This will cause
the header to repeat at the top of each subsequent page onto which the
group's detail rows flow.

In the group header's Format event procedure put:

MoveLayout = False

This will cause the header to print on the same line as the first detail.

Ken Sheridan
Stafford, England

 

[jyoung729]

That is what I want however, I want multiple columns of that information on
one page and I don't want the sizes to repeat (ie. keg, case, can, btl). I
only want those to show once on the page down the left side. Continuing with
this example, there are many beers and they will all have those same four
sizes for pricing. So the page will look like this:

Beer 1 Beer 2 Beer 3 Beer 4
Keg $15.29 $20.64 $17.39 $16.16
Case $3.47 $5.37 $4.78 $4.22
Can $1.29 $1.98 $1.49 $1.65
Btl $1.13 $1.76 $1.35 $1.47

 

[Steve]

To get that type of display, you need a crosstab query. This is a shot in
the dark but try adding a table named ProductType to your database and field
named ProductTypeID to your product table. Include ProductTypeID in your
crosstab query then group on ProductTypeID.

Steve

 

[Duane Hookom]

There might be a solution in the KB http://support.microsoft.com/kb/210044
which describes how to display a single label on the left for multiple
columns.