Layout Inquiry

[allstar45]

I have 2 tables tblBig and tblSmall.

tblBig has 2 fields BigID and name (string)
tblSmall has 3 fields SmallID, contents (string) and BigID



tblSmall contains multiple paragraphs of tblBig's name

my qry(record source) joins the two and shows tblBig.name and tblSmall.contents.

what I want is a report that displays the name and then all the contents of that name.

NAME1

contents of NAME1 1

contents of NAME1 2

contents of NAME1 3

contents of NAME1 4

contents of NAME1 5

NAME2

contents of NAME2 1

contents of NAME2 2

contents of NAME2 3

NAME3

contents of NAME3 1
...
contents of NAME3 100

NAME4

NAME5

contents of NAME5 1




and so on...



my report right now has "name" in the page header and 1 contents in the details.

This does not work, because I get name printed at the start of every page.

Is there something I can do with subreports perhaps?

[aytee111]

You should be able to use a normal report for this. How did you create the report? The first thing is to ensure that your record source (running the query independently) shows the data as you want to see it on the report. Then use the report wizard to lay it out for you, using the grouping options.

[allstar45]

Using the wizard, I found out that you can have more customised headers, in this case I was able to make a "name" header

Thanks!