Creating a numbered list

M

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

Marshall Barton

Mike W said:
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).
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top