By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

Access Report using Grid

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<km****@stcroixknits.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
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


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.
Nov 13 '05 #2

P: n/a
Thanks!!! That worked great.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.