Multiple entry Field

[Joseph]

Hello

I have a timecard database that should report on an employee that works a forty hour week.That is simple enough but when the employee works only 24 hours and uses various codes to make up the rest of the forty hour work week such as 8 hours personal or 8 hours vacation, it becomes difficult to track since i am creating more fields for each code which makes the reports and forms look filled up with fields.Does the combo box serve this purpose on a form where i can enter the various codes that pertain to the hours of the employee or do i use a drop list in the table design?Thanks

 

[Duane Hookom]

What do you mean by " i am creating more fields for each code "? What is
your table structure?

--
Duane Hookom
MS Access MVP
--

Hello,

I have a timecard database that should report on an employee that works a

forty hour week.That is simple enough but when the employee works only 24
hours and uses various codes to make up the rest of the forty hour work week
such as 8 hours personal or 8 hours vacation, it becomes difficult to track
since i am creating more fields for each code which makes the reports and
forms look filled up with fields.Does the combo box serve this purpose on a
form where i can enter the various codes that pertain to the hours of the
employee or do i use a drop list in the table design?Thanks

 

[John Vinson]

Hello,

I have a timecard database that should report on an employee that works a forty hour week.That is simple enough but when the employee works only 24 hours and uses various codes to make up the rest of the forty hour work week such as 8 hours personal or 8 hours vacation, it becomes difficult to track since i am creating more fields for each code which makes the reports and forms look filled up with fields.Does the combo box serve this purpose on a form where i can enter the various codes that pertain to the hours of the employee or do i use a drop list in the table design?Thanks

"Fields are expensive, records are cheap".

I'd suggest recording each block of work in a separate record with the
type of time indicated; e.g.

6/7 8.0 Straight Time
6/8 4.0 Straight Time
6/8 4.0 Personal
6/9 8.0 Vacation
6/10 1.0 Personal
6/10 7.0 Vacation

<etc.>

A Combo Box would indeed be a suitable tool for entering the type of
time - but it can only enter one value per record; if you're trying to
get all 40 hours into a single record, it'll be a lot more difficult.