Solved

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

Posted on 2014-10-29
7
142 Views
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.
Database101.accdb
Events-Report.jpg
0
Comment
Question by:cssc1
  • 5
7 Comments
 
LVL 19

Expert Comment

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

ET
0
 
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.

ET
0
 
LVL 34

Expert Comment

by:PatHartman
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.
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 19

Expert Comment

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

ET
0
 
LVL 19

Accepted Solution

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

ET
Database101-Fixed.accdb
0
 

Author Closing Comment

by:cssc1
ID: 40412328
Thanks for sharing your talent
0
 
LVL 19

Expert Comment

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

ET
0

Featured Post

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)

Join & Write a Comment

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

747 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

16 Experts available now in Live!

Get 1:1 Help Now