Creating a numbered list

[Mike W]

Hello,
I created a database that lists all my CDs. I have a report that prints
the Artist Name, CD Title, Track Number, and Track Title. I have it so it
sorts them by Artist name, then by CD Title. What I would like to do is have
it print a sequntial number in front of each CD. But I don't want to have
this number be a static number for that CD. What I would like to happen is
if for example I had 2 CDs in the database it would print someting like:
Aerosmith
CD # 01 Big Ones
Tracks here
Bon Jovi
CD # 02 Slippry WHen Wet
Tracks here

Then if I would ad a CD to the list, and it would go between them, the new
report would look something like this:
Aerosmith
CD # 01 Big ones
Tracks Here
Bangles
CD # 02 Greatest Hits
Tracks Here
Bon Jovi
CD # 03 Slippry When Wet
Tracks Here

If anyone can give me any suggestions on how to do this in a report that
would be great.

Thanks,

Mike W.

 

[Marshall Barton]

I created a database that lists all my CDs. I have a report that prints
the Artist Name, CD Title, Track Number, and Track Title. I have it so it
sorts them by Artist name, then by CD Title. What I would like to do is have
it print a sequntial number in front of each CD. But I don't want to have
this number be a static number for that CD. What I would like to happen is
if for example I had 2 CDs in the database it would print someting like:
Aerosmith
CD # 01 Big Ones
Tracks here
Bon Jovi
CD # 02 Slippry WHen Wet
Tracks here

Then if I would ad a CD to the list, and it would go between them, the new
report would look something like this:
Aerosmith
CD # 01 Big ones
Tracks Here
Bangles
CD # 02 Greatest Hits
Tracks Here
Bon Jovi
CD # 03 Slippry When Wet
Tracks Here

Use a txt box with control source =1 and RunningSum set to
Over All (or Over Group if you want to number categories
separately).

 

[Mike W]

Thanks, that appears to work. I didn't realize it was that easy. I was
trying to all kinds of complicated functions, none of which we working.

Thanks again.