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

  • Thread starter Thread starter jdgretz
  • Start date Start date
J

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
 
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.
 
Back
Top