Solved

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

Posted on 2014-10-29
7
145 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 35

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
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…
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…

773 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