entering time by lookup table?

  • Thread starter Thread starter Ching Hsu
  • Start date Start date
C

Ching Hsu

I am trying to build a database to do personnel scheduling,- just to learn
how it will be done.
Entering the hour and minutes seems too tedious, so I have a look up table.
But, the access tells me that I can't use time data type as a lookup value.
What is the best way to enter and calculate the time ie, hour and minutes..
thanks,
Chin
 
In my opinion, the best way is to go back to typing them in - I can't think
of any other way (combo boxes, date-time pickers, whatever) that isn't even
*more* tedious.

However, if you really want to, you could use two integer fields (one for
hours and one for minutes) or you could use a single text field, and use
code to parse the hours and minutes from the text and convert the text
values to numbers.
 
Back
Top