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 online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,009
    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
    8,684
    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??
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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
  •  
Tech Forums: Microsoft Office Forums