Reports To Display Number Beside Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Responder NameI am working on a method for a database that a Fire Department
will use. The problem I am having is that there should be a number beside
the record. The Primary Keys are RUN No. which is associated with
Responders (Run ID Repeated for each record associated with it). Then
Vehicles (RUN ID Repeated with each record associated) . My Goal is that the
report will be able to place a Number beside each of the records starting
from 1 and ending at 16.

the ultimate goal for this is so that the report will be able to space the
charachters such as this.

[No] [Responder] [No] [Responder]
1. Responder Name 9. Responder Name
2. Responder Name 10. Responder Name
3. Responder Name 11. Responder Name
4. Responder Name 12. Responder Name
5. Responder Name 13. Responder Name
6. Responder Name 14. Responder Name
7. Responder Name 15. Responder Name
8. Responder Name 16. Responder Name

The goal is that when the Run ID changes then the No Field will set itself
back to 1. and count up until the Run ID Changes Again.

How would I Do this in access????

This is a very good question becuase i know of a few people who would love
to try it.
 
Eric R. Clark said:
Responder NameI am working on a method for a database that a Fire Department
will use. The problem I am having is that there should be a number beside
the record. The Primary Keys are RUN No. which is associated with
Responders (Run ID Repeated for each record associated with it). Then
Vehicles (RUN ID Repeated with each record associated) . My Goal is that the
report will be able to place a Number beside each of the records starting
from 1 and ending at 16.

the ultimate goal for this is so that the report will be able to space the
charachters such as this.

[No] [Responder] [No] [Responder]
1. Responder Name 9. Responder Name
2. Responder Name 10. Responder Name
3. Responder Name 11. Responder Name
4. Responder Name 12. Responder Name
5. Responder Name 13. Responder Name
6. Responder Name 14. Responder Name
7. Responder Name 15. Responder Name
8. Responder Name 16. Responder Name

The goal is that when the Run ID changes then the No Field will set itself
back to 1. and count up until the Run ID Changes Again.
Click to expand...


I don't unserstand how you want these numbers assigned, but
it's easy to just get a sequential count of the records.

Set the [No] text box's ControlSource expression to =1 and
its RunningSum property to Over Group.
 
Back
Top