I need some help making a form look like a pivot table; however I want to be able to change the data in the fields. I have a main table with 3 fields (Date,EmployeeID and AssignmentID). The last 2 fields are linked from the Employee and Assignment tables. Each Employee will be assigned something (RR, RM 1, SCHED, PRE for example) on a specific date. The assiggnments could change from day to day. I want to look at a given week, say Monday thru Friday. I have attached a sample screenshot of what I want to accomplish. This is what I have brainstorm about:
Adding MDate,TDate,WDate,TTDate and FDate fields to the main table and limiting the Date allowed into M,T,W,TT,F accordingly, so that only Monday dates fall into MDate and so on. This way a row could be represented by one record.... is this the right approach?
I am farily new to Access, but I can understand most of the concepts. Any help would be greatly appreciated.
Adding MDate,TDate,WDate,TTDate and FDate fields to the main table and limiting the Date allowed into M,T,W,TT,F accordingly, so that only Monday dates fall into MDate and so on. This way a row could be represented by one record.... is this the right approach?
I am farily new to Access, but I can understand most of the concepts. Any help would be greatly appreciated.
