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
  • 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 34

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.
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
bind Combobox 4 29
data analyst 3 49
Create Form using Wizard 14 33
Set Query Column Heading parameters through VBA for CrossTab query 6 26
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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 …

910 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now