2 column report

[Jeff]

How can I create a 2 column report with 2 headers always at the top and the
detail section to be 2 columns

For example
-----------------------------------------------------------------------------------
Frank Sinatra (Artist1)
Fly By the Moon (Album1)
Summer Wind (song1) How
Insensitve(song2)
Thats Life (song3)
September Song (song4)
My Way (song5)
Witchcraft (song6)

Classic Songs (Album2)
Nice 'N' Easy(song1) My Funny
Valentine(song2)
Chicago(song3) Three
Coins In A Fountain(song4)
-------------------------------------------------------------------------------------

2 columns for songs and 1 column for Artist and Album

Thanks,

Jeff

 

[Jeff]

Sorrry, I meant for it to look like the following:

Artist1

song1 song2

song3 song4

song5 song6

song1 song2

song3 song4



song1 song2

song3 song4

song5 song6

song1 song2

song3 song4

2 columns for songs and 1 column for Artist and Album

 

[Duane Hookom]

You could base your main report on the Album and Artist information and
place the songs in a 2 column subreport that displays across then down.

 

[Marshall Barton]

Sorrry, I meant for it to look like the following:

Change the report's record source to a query that just
retrieves the Artist and album data. Group on the artist
field and place the album field in the detail section.

Then, create another report using the original query. Set
it to two columns using Across then Down snaking.

Now add the new report as a subreport in the first report's
detail section. Set the Link Master/Chlid properties to the
artist and album fields.

 

[Jeff]

I attempted that using 2 queries and 2 reports (1 embedded) with 2 columns
song report, however, I was unsuccessful.

Am I supposed to put both the Album and the subreport into the Detail
Section ... that doesn't seem to work

 

[Duane Hookom]

Placing bothe the Album and the subreport in the detail section does work if
your record sources of your report and subreport are correct.

We don't know your 2 queries and we don't understand what you mean when you
say "I was unsuccessful".

--
Duane Hookom
MS Access MVP
--

I attempted that using 2 queries and 2 reports (1 embedded) with 2 columns
song report, however, I was unsuccessful.

Am I supposed to put both the Album and the subreport into the Detail
Section ... that doesn't seem to work

 

[Jeff]

Sorry, you're correct, it does work!!

Thanks very much, i appreciate you taking the time to reply

Jeff

Placing bothe the Album and the subreport in the detail section does work
if your record sources of your report and subreport are correct.

We don't know your 2 queries and we don't understand what you mean when
you say "I was unsuccessful".