Sabtu, 03 November 2012

[MS_AccessPros] time tracking DB

 

Hello,

I'm starting to work on a time tracking DB to keep track of time spent on different projects

my main table has a series of columns, (date, user, department, project, time, description, ...)
look-up sub tables, (users, departments, projects)

only issue is if people forget to enter time on previous days it will be hard to see the days they missed

i would like to have a form that shows a calendar that shows the total number of hours for a certain person on each day
then selecting a day should show a sub form list of times for that particular day and then maybe another form for detail for one time entry

any better suggestion on how to make this more user friendly?

also what is the simplest way to create a calendar?
(currently i have a table with all days for one year, one column of ID's and one column of dates)

thanks,

d

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar