Help please

[superrob5]

I have a table that has employee information
EmpId
FirstName
LastName
Address
Dob
etc....

I am not sure but I was asked to create a db that will keep track of the employees hours per month to the year. For instance
for example
Rob
1999 Jan 10 hours
Feb 10 hours
Mar 10 hours
April 10 hours
May 10 hours
etc.





See on the form I would like it to already have the months on the form and all the user has to do is type in the hours for that month. but not sure what to do with the field year. How would I accomplish this on the form or the table I am not sure how to.


Rob

 

[ColinEssex]

I should think 2 ComboBoxes would suffice for month and year. A bit like the internet booking system for hotels etc.

The link to the second table would be by the IDNo not the name.

Col

 

[superrob5]

but then on the screen will I be able to have a running total of the year. For instance if I select 1999 in the box will I have a running total of that year?????



Rob

 

[ColinEssex]

You can have that in a subForm.