Results 1 to 4 of 4
  1. #1
    911Muppet is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    2

    Database Design for Rotation Assignments


    I'm building a DB for a mentor-ship program and just can't seem to find what I'm looking for. I am looking for a way to auto-assign a mentor to a new addition to the DB - for example: I have a checkbox field that, when checked, will automatically assign the next name from a rotating list of names in the next field. I feel like it might be a macro or formatting formula, but also think I'm overthinking it. I'm new to Access so my skills are still in development, and decided to seek help from the Pros! Currently I just have a dropdown list, but am looking for something that will assist with the rotation aspect so I don't have to keep a separate log of who's up next.

    Thank you in advance for any help, guidance, or assistance you might be able to offer!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you could have a date field in the tMentor tbl. DateAssinged
    MentorID, MentorName, DateAssigned, etc,...

    to get the next person , grab the MIN of the list
    vMentorID=Dmin("[DateAssigned]","tMentors")

    then that person gets assigned to the next entry, and their date gets = Date() if assigned.

  3. #3
    911Muppet is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    2
    I will give this a shot! Thank you!

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Is this going to be a multi user dB?

    Quote Originally Posted by 911Muppet View Post
    .... will automatically assign the next name from a rotating list of names in the next field.
    How are you determining who should be assigned next?

    Maybe you would post your dB??

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

Similar Threads

  1. Replies: 1
    Last Post: 12-12-2013, 03:38 PM
  2. Handling Historical Data with different assignments
    By crimedog in forum Database Design
    Replies: 5
    Last Post: 12-12-2013, 09:43 AM
  3. Column assignments in an INSERT INTO type of query.
    By tfulmer in forum Import/Export Data
    Replies: 3
    Last Post: 05-01-2013, 01:42 PM
  4. Text rotation on a report
    By Madmax in forum Reports
    Replies: 1
    Last Post: 07-12-2011, 03:35 PM
  5. Text box rotation
    By Pauldk in forum Reports
    Replies: 0
    Last Post: 12-29-2008, 08:46 AM

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