How do I create and populate a grid within an Access Report

[jdgretz]

I need to create a report that looks something like this in the detail
section for each customer. Report will be grouped by customer or CustID.


Customer Name Additional Data Some More Data <----- will always be 1
line

Book1 Book2 Book3 Book4 Book5
Book6 Book7 Book8 Book9 Book10

:
:
:
Booklast <----- can be any number of lines

The variable list comes from a linked table and is the many in a one-to-many
relationship. Having the list print down in a single column is not
desirable. The number of items for each customer is not known.

Can this be done with a SQL statement within the report or will it need to
be written in VB?

I'm sure there is something simple that I'm simply overlooking.

Thanks,

John

 

[bcap]

Maybe your "grid" needs to be a columnar sub-report. Try creating a report
which lists the books, and then experimenting with the column settings
(which you will find under Page Setup). You can create a columnar report
which prints across and then down. Once you've got it right you can include
it under the customer line as a sub-report.

 

[jdgretz]

I'll give that a try - sounds like it will do that job - Thanks,

jdg