How to add "Event Number" before a sorted event?

Posted on 2014-10-29
Last Modified: 2014-10-29
i have a Report named Events. The events report simply lists the accident events in order of date the time. I am trying to add the following to automatically add "Event 1 - , Event 2 - , Event 3 - , Etc..." before each event description.

I searched online and in books to find an example of how to do this, can't find any.

I attached a sample db and report.

Any help is a blessing.
Question by:cssc1
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
LVL 19

Expert Comment

by:Eric Sherman
ID: 40411474
Can't download your sample db.  Try re uploading a valid .accdb file.

LVL 19

Expert Comment

by:Eric Sherman
ID: 40411492
Without seeing the layout of your report, you could try the following.

1.) Add a hidden text control (TxtCounter) to use as a counter in the detail section of the report. Set its value to =1 and the running sum property to over all or what ever is appropriate.  
2.) Create another text control in the detail section and set the control source value to ="Event" & " " & TxtCounter.

LVL 36

Expert Comment

ID: 40411773
etsherman, I have the same problem with .accdb files (can't download them).  The problem is caused by an incompatibility between IE and the way this site encodes file types.  Try another browser if you have one available.  The site managers are aware of the problem but I don't know if they are going to fix it.
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

LVL 19

Expert Comment

by:Eric Sherman
ID: 40411832
Thanks for the info Pat.

LVL 19

Accepted Solution

Eric Sherman earned 500 total points
ID: 40411868
See report in the attached modified sample db.


Author Closing Comment

ID: 40412328
Thanks for sharing your talent
LVL 19

Expert Comment

by:Eric Sherman
ID: 40412337
Glad I could help.


Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question