How to add "Event Number" before a sorted event?
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
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
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
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
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.
Thanks for the info Pat.
ET
ET
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for sharing your talent
Glad I could help.
ET
ET
ET