Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2005

Tip: Looking for answers? Try searching our database.

Creating a numbered list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike W - 26 Oct 2005 16:52 GMT
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).
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.