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.

 

[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.