Prev: Null Values
Next: Roman Numeral
From: safenia on 22 Feb 2010 10:58
I have the following table:
I have organized my cds writing down the name of the cd, the artist, the
type of music and the tracks..
I want to make a report that contains the above info in the following order
(hierarchy):
type of music
artist
name of cd
tracks
without repeating entries (ie when the artist changes but not the type of
music, I don't want the type to appear again)
please note that I am a new access user!

From: Steve on 22 Feb 2010 11:55
Create a query and put the fields in the order you have here. Sort ascending
on type of music and artist. Use the query as the recordsource of your
report. In the report design, group on type of music.

Steve
santus(a)penn.com


"safenia" <safenia(a)discussions.microsoft.com> wrote in message
news:BA71D605-3354-4CFF-8D10-D913A5619EB5(a)microsoft.com...
>I have the following table:
> I have organized my cds writing down the name of the cd, the artist, the
> type of music and the tracks..
> I want to make a report that contains the above info in the following
> order
> (hierarchy):
> type of music
> artist
> name of cd
> tracks
> without repeating entries (ie when the artist changes but not the type of
> music, I don't want the type to appear again)
> please note that I am a new access user!
>


 | 
Pages: 1
Prev: Null Values
Next: Roman Numeral