I am looking for a grid control that I can use in an Access report. I
have seen Stephan Lebans solution for PrintLines, MS's Dynamic Crosstab
query, and several others. However, none of them work for me. I need
to be able to list available ColorIDs and ColorNames in columns 1 & 2
and available Sizes in the column headings. The problem comes when
there isn't enough room to display all of the Sizes. What I would like
to do is have one grid with all available colors and the first 7 (or
whatever fits) sizes and then subsequent grids below with the rest of
the sizes. Below is an example:

Grid 1:

Small Medium X-Large XX-Large
Red * * *
Black * *
White


Grid 2:
XXX-Large Large-Tall XX-Large-Tall
Red * *
Black *
White * *

The asteric indicates that an item is available in that color/size.
Any ideas or solutions would be great. Thanks!

Ken

<kmacon@stcroixknits.com> wrote in message
news:1114551111.529849.139530@g14g2000cwa.googlegr oups.com...[color=blue]
> I am looking for a grid control that I can use in an Access report. I
> have seen Stephan Lebans solution for PrintLines, MS's Dynamic Crosstab
> query, and several others. However, none of them work for me. I need
> to be able to list available ColorIDs and ColorNames in columns 1 & 2
> and available Sizes in the column headings. The problem comes when
> there isn't enough room to display all of the Sizes. What I would like
> to do is have one grid with all available colors and the first 7 (or
> whatever fits) sizes and then subsequent grids below with the rest of
> the sizes. Below is an example:
>
> Grid 1:
>
> Small Medium X-Large XX-Large
> Red * * *
> Black * *
> White
>
>
> Grid 2:
> XXX-Large Large-Tall XX-Large-Tall
> Red * *
> Black *
> White * *
>
> The asteric indicates that an item is available in that color/size.
> Any ideas or solutions would be great. Thanks!
>
> Ken
>[/color]

Lookup "IN" in the Pivot part of a cross tab query, you will be able to
identify the columns.
It will even create a column with no data.

Thanks!!! That worked great.