Adding new field

[Guest]

I am a relative novice to Access. I need to be pointed in the right
direction. I was originally asked to make a database that could build
reports showing the hours each employee worked on their specific tasks and
broken out daily, monthly or yearly. I set up 3 tables. One contained an
operator no. and the employee's name. Another contained a job code and the
name of the job. The other contained the date, the operator no., jobe code
and the time the job took. With this I was able to get the needed reports.

Now, I was asked to expand this database to include the volume processed.
The problem is not all jobs porcess work. For instance, their is the daily
maitenence of machine which all shift must do. From everything I have read,
I should not just add a volume field to my third table as there would be many
"blanks" in the table. What would be the best solution to keeping the data
input fairly simple? As of right now only one form is used to enter the
data. Any help would be great.

 

[Guest]

Hi Scott,

Now, I was asked to expand this database to include the volume processed.

Can you provide examples of what this means? What percentage of the records
would include an entry in the volume field?

What would be the best solution to keeping the data
input fairly simple?

"Best" is in the eyes of the beholder. Adding this field to your third table
certainly sounds like the easiest solution. If you really want to, you could
break this field out to another table that is related 1:1 to this table, but
the cost (added difficulty) would likely outweight any benefits of doing so.
Given what you have provided so far, I'd be inclinded to just put this field
in your third table.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________