Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Any ideas??? Continuous fixed fields in row...

Status
Not open for further replies.
RonnieDobbs

RonnieDobbs

MIS
Aug 4, 2004
84
US
Not quite sure how one might do this but I thought I would post to see if anyone had any ideas. Basically there are 4 people who rotate passing or failing assignments. They go in the same order every day when the assignments come in. Now, we have the assignment numbers in different colours written up on a dry erase board. Very inconvenient. I have been trying to figure out how to use MS Access maybe to make this easier. A basic data sheet form??? How would I get rows to automatically populate with the 4 employees? if a assignment is failed, it should stay on the screen, and if passed, there is no need to have it shown...

Sorry, kind of abstract...Any advice would help, would Excel be easier?

Thanks,

AB
 
Sort by date Sort by votes
One thing I think you will need will be an Assignment Order Table, which will simply represent your circular queue. It will have the PersonID and FollowupPersonID and look like
this
PersonID FollowupPersonID
1 2
2 3
3 4
4 1

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
 
Upvote 0 Downvote
I don't think I have enough information to help you.

What does "rotate passing or failing assignments" mean? Does each person get one assignment at a time? What does he or she do with it? How many assignment numbers are written on the board at a time? I assume that each color represents one person? Do the assignments have to be processed in the order received? If there are forty assignments turned in, can you have person A handle the first ten, and person B the next ten, and so on? Or must you go ABCDABCDABCD? What if person B finishes an assignment before A is done?

-------------------------------------
It is better to have honor than a good reputation.
(Reputation is what other people think about you. Honor is what you know about yourself.)
 
Upvote 0 Downvote
I think you have to populate who is assigned using code or an application or a program of some kind. i.e. Divide by 4 and use the remainder to select whose name goes in there. If for every day there is a field that auto numbers the failed assignments based on a querry of failed assignements you could take the auto-numerated field and divide by 4 to get a computed field and have that linked to a joining table to join it to the right follow-up person. This might mean you have to write it as a querry based on the date the assignment or test was taken.

One thing one might ask is how do you determine the order of the assignments. This requires them to be ordered and entered somehow as they are turned in. This might be a date/time order they were completed. This would require someone to acutally enter that information.

If you do not like my post feel free to point out your opinion or my errors.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Harami12
  • Locked
  • Question
Where to Next in Programming 2
Replies
2
Views
186
Andrzejek
Andrzejek
LuciusThorne
  • Locked
  • Question
Database Design - Reusing one-to-many relationship in a table?
Replies
4
Views
170
mintjulep
M
bghosh
  • Locked
  • Question
Blank Lines in SQLPLUS output.
Replies
0
Views
135
bghosh
bghosh
Andrzejek
  • Locked
  • Question
Manager issue in DB
Replies
8
Views
165
Olaf Doschke
Olaf Doschke
Andrzejek
  • Locked
  • Question
PK – FK multi-fields question
Replies
6
Views
135
Olaf Doschke
Olaf Doschke

Part and Inventory Search

Sponsor

Back
Top