Results 1 to 3 of 3
  1. #1
    brharrii's Avatar
    brharrii is offline Advanced Beginner
    Windows XP Access 2010 64bit
    Join Date
    Jun 2012
    Location
    Seattle, WA
    Posts
    63

    Red face Creating a monthly report that shows rotating chore list

    I have two tables, one has a list of chores that must be done once a month and the other is a table of who those chores can be assigned to. There are the same number of chores as there are people. Each month the chores rotate so each person gets a new chore until everyone has done each chore once and then start over again.


    I'd like to setup a report that prints off the current list of chores and who they are assigned to for the current month.

    Does anyone have any ideas on how I could do this?



    Thanks

    Bruce

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Look at this template as it may do what you want with some small or no modifications.

    http://www.rogersaccesslibrary.com/forum/topic18.html

  3. #3
    brharrii's Avatar
    brharrii is offline Advanced Beginner
    Windows XP Access 2010 64bit
    Join Date
    Jun 2012
    Location
    Seattle, WA
    Posts
    63
    Thanks for your reply alansidman. I'm trying to figure out how to use the database now, I'll keep you posted

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

Similar Threads

  1. Replies: 6
    Last Post: 11-10-2012, 09:49 PM
  2. Report with monthly totals?
    By KrisDdb in forum Access
    Replies: 7
    Last Post: 12-06-2011, 11:49 AM
  3. Rotating list of names
    By bkvisler in forum Access
    Replies: 15
    Last Post: 07-27-2011, 06:49 PM
  4. List in Report Shows All Items in Table, But I Only Want...
    By italianfinancier in forum Programming
    Replies: 1
    Last Post: 05-28-2011, 02:42 AM
  5. Query + monthly report
    By tareksul in forum Reports
    Replies: 3
    Last Post: 12-19-2010, 01:09 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