Jim-
Probably not. I assume you already have Supervisor and Department tables. You also need an Employees table.
tblTasks:
TaskID
Supervisor ID
Department ID
Task
Type
tblTasksEmps:
TaskID
EmployeeID
(If you want to limit to 2 employees per task, you'll have to write code to disallow adding a third employee to a task.)
tblTasksActivity
TaskID
YearMonth
Activity (I assume there's something in the intersection of months and tasks.)
If an activity needs to be tracked by employee, then you'll also need an EmployeeID in tblTasksActivity.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On May 23, 2014, at 2:12 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
| I am trying to convert a spreadsheet with the months as columns across the top and names on the left and the data for each month pertaining to the names would be check boxes. There would be a need for years obviously. Do I create a table with each of the months as one field or each month being its own field? I just cannot picture it in my head. the fields would needed are Supervisor ID (is a number assigned to the Supervisor) Department ID (is a number assigned to the Department) Employee Name 1 (there are 2 employees assigned to a task) Employee Name 2 (there are 2 employees assigned to a task) Task (the name of the task) Type (the task type) Month (the month the task was completed) Thank You for any assistance Jim Wagner Sent from Yahoo! Mail for Windows 8 |
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar