If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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:

1AM
3AM
5AM
7AM
9AM
11AM
1PM
3PM
5PM
7PM
9PM
11pm
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.