Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2005
    Posts
    21

    Unanswered: Room assignment Generator

    Alright, I think I have heard someone do this before with Access. I need to be able to assign 25 students per room. But these rooms will have criteria. Here are the following criteria.

    9th graders - Not testing go into rooms.
    10th graders - All are testing and have to go to specific rooms.
    11th graders - Testers go to specific rooms and non-testers go to specific rooms.
    12th graders - Go to non-testing rooms.

    Is there a way to produce a generator that will go through the fields and look for the GRADE LEVEL and if they ARE TESTING or not TESTING and put them in the rooms that are identified. Example: Room 1 - 50 are for all 10th grade testers. So I want 25 students per room. Is that possible? Please advise.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Are all rooms named like that (consecutive integers)? Do all the combinations you mention result in consecutive rooms? Do you want the assignment balanced (e.g. for the rooms you mention, all 50 rooms used with students spread evenly between them) or 25 in the first room, 25 in the next room, 25 in the next until all students accounted for, even if this leaves rooms unused?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    I hate trying to divine algorithms. Try this: get some index cards, write one for each student with name, grade and testing. Then, one by one, put them in rooms and explain why each student went in a different room.
    Last edited by sco08y; 09-20-08 at 22:36.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Way to automate sco08y ^.^

    Without analysing the exact way to do what you want, I would just say YES, it's possible. The rest is semantics.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Quote Originally Posted by StarTrekker
    Way to automate sco08y ^.^
    Well, the idea was that after the OP went through this process, s/he'd post the psuedocode...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •