how to manipulate repeated entries

  • Thread starter Thread starter safenia
  • Start date Start date
S

safenia

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!
 
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
(e-mail address removed)
 
Back
Top