Rotating Data - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Rotating Data

Daniel Palo

3 years ago

I'm not sure if this will be in the realm of Access but here goes:

I work in a hospital where we use a small access database that I've created to monitor pertinent patient data for our department. This group has helped me before so I figure I'd ask again.

I have 3 nurses that are assigned to our small patient group and I have that part managed. What I have been asked to do is provide a printable report that shows the weekly assignments for my RN's. Inpatient, Clinic, and Outpatient. These assignments rotate weekly in that order. I have been using a spreadsheet with manual entries every month and would like to automate this process. I will try and post a picture of the Excel screen.

Is this possible in Access? I've watched a few of the calendar videos of Richard's but not sure I can make them work for this.

	Daniel Palo OP @Reply 3 years ago

	Adam Schwanz @Reply 3 years ago
It's usually not a question of if it's possible, but how hard is it. Right now off the top of my head, all I can think of is to make a temporary table, then use a recordset to add records to that table and assign what they're doing on which day and to handle the rotations automatically. Then base your report on that table.

	Adam Schwanz @Reply 3 years ago
Also that may be way over your head, recordsets are a developer level tool and I'm not too sure if your experience with vba, but that is one way that would work to get the report to work, there may be a simpler way that someone else knows but I can't think of it right now.

	Daniel Palo OP @Reply 3 years ago
I'm not familiar with recordsets but I'll check it out. Thanks.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View