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 - 26 Oct 2005 17:04 GMT
> 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
[quoted text clipped - 20 lines]
> 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).

Signature
Marsh
MVP [MS Access]
Mike W - 26 Oct 2005 17:51 GMT
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.
> > 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
[quoted text clipped - 24 lines]
> Over All (or Over Group if you want to number categories
> separately).