Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Posts
    1

    Simple but hard question

    I'm trying to use access to prepare for a swimming race.
    I want the report to show who got which lane.
    This is how it works.

    if we have 8 swimmer or less
    then this is how it pick the position
    name Speed
    A 30Sec
    B 31Sec
    C 33Sec
    D 36Sec
    E 38Sec
    F 39Sec
    G 41Sec
    H 44Sec

    Position Chart
    Lane
    1 G
    2 E


    3 C
    4 A
    5 B
    6 D
    7 F
    8 H

    But if Swimmer is greater than 8, then it will divided in to 2 groups, forming a V Shape like this

    Position Chart for Greater than 8 but not more than 16
    Group 2
    Lane
    1 N
    2 J
    3 F
    4 B
    5 D
    6 H
    7 L
    8 P

    Group 1
    Lane
    1 M
    2 I
    3 E
    4 A
    5 C
    6 G
    7 K
    8 O

    Where do I get this position?
    It's like this
    Lane 1 2 3 4 5 6 7 8
    Group1 14 10 06 02 04 08 12 16
    Group2 13 09 05 01 03 07 11 15

    The question is, how can I create a report which I can set the location of each data? or any easier way to do it?

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109

    Do you have Excel?

    I would think using Excel would be easier. Enter the swimmers in one column and their time in another column. Sort in ascending order based on time of the swimmers. Copy the swimmers name by time to your lane assignment

    Place Group Lane Swimmer
    1 2 4 A
    2 1 4 B
    3 2 5 C
    4 1 5 D

    etc.

    Do another sort by group and then lane in ascending order. Copy and Paste the swimmers to another sheet, formatted the way you want. You could record the steps into a macro to have it done automatically to use again, but don't forget to resort your lane assigments by place again.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Extremely simple ACCESS DB
    By austin3i62 in forum Access
    Replies: 1
    Last Post: 02-07-2008, 11:51 AM
  2. Should be simple Query Question
    By brj1 in forum Queries
    Replies: 2
    Last Post: 03-04-2006, 01:11 PM
  3. Simple record lookup?
    By Transeau in forum Access
    Replies: 0
    Last Post: 01-18-2006, 10:27 PM
  4. Probably a simple report question
    By gmurrie in forum Reports
    Replies: 1
    Last Post: 12-28-2005, 09:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums