Help...

I have a form that has a seperate delivery date and time field (field format for the Time field is "short date") which the user enters.. I then have a update query that populates another field with either AM or PM depending on the Time field.... sounds simple enough, yet the results are not correct. For instance 23:00 hours should show up as a PM and does not.... Any ideas??