2 column report

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
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.
 
Jeff said:
Sorrry, I meant for it to look like the following:
Click to expand...


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

Jeff said:
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
Click to expand...
 
Sorry, you're correct, it does work!!

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

Jeff


Duane Hookom said:
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".
Click to expand...
 
Back
Top