entering time by lookup table?

[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

 

[Brendan Reynolds]

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.