Show the Position on a Waiting list

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

Guest

I have an access Dbase set up to show 300 records or so which is sorted by
groups then by points, It then has a report sorted by groups and then
descending points, the report is then too big to show position at a glance,
Can I show the position of each record for each sub group?
The number of applicants change so a pre printed grid will not work?
 
If you want to simply number your records within your groups, you can add a
text box to your detail section:
Name: txtSeq
Control Source: =1
Running Sum: Over Group
 
The field I wish to populate Column E shows the position on a list [form a
table a-e across the top then 1 record on each row]
The table is sorted & grouped by Column A ascending, Sorted & Grouped by B
Ascending, Sorted by C Descending, E-POSITION should show the records
placement on the list 1st, 2nd, 3rd.
Column E shows what place a record is on the list
Problem One Position must start at 1st 2nd 3rd in each Grouping.
Problem Two more than one record will have the same value in Column C so 5
records can be 1st and 12 can be 2nd
Hope I have explained the problem better
 
If you want repeating numbers for position in the list, you would need to
use a column in your report's record soruce that generates the number.
Search the queries news group on "ranking" to find how to use DCount() or a
subquery to generate a sequence number.

--
Duane Hookom
MS Access MVP

Gary Jordan said:
The field I wish to populate Column E shows the position on a list [form a
table a-e across the top then 1 record on each row]
The table is sorted & grouped by Column A ascending, Sorted & Grouped by B
Ascending, Sorted by C Descending, E-POSITION should show the records
placement on the list 1st, 2nd, 3rd.
Column E shows what place a record is on the list
Problem One Position must start at 1st 2nd 3rd in each Grouping.
Problem Two more than one record will have the same value in Column C so 5
records can be 1st and 12 can be 2nd
Hope I have explained the problem better


Duane Hookom said:
The running sum can be done over any group or the entire report.
Click to expand...
Click to expand...
 
Back
Top