I could make it a text field I guess,
I don't want to really treat it like time.
Users are supposed to get stats every other hour on odd hours.
Sometimes they are off by a little
The lookup table is:
The dropdown box in the form looks fine, but I'd like to keep the order when running a query, as you can see above they are being sorted as characters.
Even if I set it to time, I want to have users pick form it in a combo box, and you can't set a combo box in date/time format.
As far as why a memo box, I didn't think it reserved characters so I figured it wouldn't matter if I used text or memo, they were only taking up at most 8 characters per entry. Just want it to display in the order of the lookup table it's pulling from.