Re: How to set up a table

Steven,
Thanks for your reply.

Hospital people think like that. The day starts at 7 AM!

I had thought of doing DateTime, which will work. Since they won't  be 
entering the DateTime themselves, I'll have the computer populate the
table 
with all the Date/Times.

I was looking for any out of the box thinking.

Again,
Thanks,

Craig

"Steven Green" <greens@[EMAIL PROTECTED]
> wrote in message 
news:47349b4a@[EMAIL PROTECTED]
>> I was thinking about adding the hour # to the hour such as  1-0700, 
>> 2-800, 3-0900 though 24-0600 as a string for that key field.
>
> you said you wanted to set this up like people think.. who thinks like 
> that? (g)
>
> how about simply using date / time ???
>
> --
> Steven Green - Myrtle Beach, South Carolina USA
>
> Diamond Software Group
> http://www.diamondsg.com/main.htm
> Paradox Sup****t & Sales
>
> Diamond S****ts Gems
> http://www.diamondsg.com/gemsmain.htm
> S****ts Memorabilia and Trading Cards
>
> "Craig" <craig.futterman@[EMAIL PROTECTED]
> wrote in message 
> news:4734989b$1@[EMAIL PROTECTED]