Timesheets

[dave]

Hello Everyone

I would guess this is a kind of common thing to want to do. I want to enter
timesheets for employees. The way I thought about doing this was to create
a table with a unique key per line, the employee ID, the weekending Date and
then monday, tuesday etc. The weekending field would allow me to print off
the timesheets for all employees on a weekly basis. By this method I have
to enter the number of hours manually for each day.

1) Is it possible to produce a form that would list each day as columns and
then for the employees to be listed below. It's like a crosstab query
except that crosstabs can only have one column I beleive?

2) Is it possible to type a start time and a finish time and have access
calculate the number of hours?

3) Is there a better way to do this??????

Thanks

 

[Arvin Meyer]

Answers in-line:

Hello Everyone

I would guess this is a kind of common thing to want to do. I want to enter
timesheets for employees. The way I thought about doing this was to create
a table with a unique key per line, the employee ID, the weekending Date and
then monday, tuesday etc. The weekending field would allow me to print off
the timesheets for all employees on a weekly basis. By this method I have
to enter the number of hours manually for each day.

1) Is it possible to produce a form that would list each day as columns and
then for the employees to be listed below. It's like a crosstab query
except that crosstabs can only have one column I beleive?

Not with native Access controls. You may find a grid control that will work.
Access crosstab queries are not editable.

2) Is it possible to type a start time and a finish time and have access
calculate the number of hours?
Absolutely.

3) Is there a better way to do this??????

If you want to use a form, just have the employee select his name from the
list. You can write code that will automatically timestamp the date/time
field in the afterupdate or click event of the list.

When you're done for the week, display the data in a report that uses a
crosstab query, or our put the crosstab to a spreadsheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[dave]

Can you enlighten me a bit on point 2?

Answers in-line:


Not with native Access controls. You may find a grid control that will
work.
Access crosstab queries are not editable.


If you want to use a form, just have the employee select his name from the
list. You can write code that will automatically timestamp the date/time
field in the afterupdate or click event of the list.

When you're done for the week, display the data in a report that uses a
crosstab query, or our put the crosstab to a spreadsheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer]

Sure. Create a query using the DateDiff function in an alias column,
something like:

HoursWorked: DateDiff("n",[TimeIn],[TimeOut])/60

Which will give you the time in minutes divided by 60, so you'll get hours
and a fraction.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access