Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Position on a waiting list (2nd request)

Discussion in 'Information Technology' started by Gary Jordan, Jul 28, 2006.

  1. Gary Jordan

    Gary Jordan
    Expand Collapse

    The field I wish to populate on a report is in Column E showing the position
    on a list [from 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 then 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 or 1 2 3 in each Grouping.
    Problem Two more than one record will have the same value in Column C so 5
    records can be joint 1st and 12 can be joint 2nd
    Hope I have explained the problem better

    Win 2000 Pro - Access 2000
  2. Loading...

Share This Page