Time problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a Time field and a field [AM/PM]. I also import excel
spreadsheet into Access table.
The user input into Excel always puts 12:00 PM.
My report needs to numerically sort 12:00 as am, so that it follows 11:30 am
for scheduling purposes.
I want to write code that will change the am/pm field to AM if the Time
field is > than 11:59 am.
I have tried
If [Time].value > #11:59:00# Then [AM/PM].value = "AM".
But it does not show up in proper place on report.
Help would be appreciated.
 
On your report, you can just put the textbox with your time field, a set the
format property to "ampm". It should show AM/PM properly !

Mauricio Silva
 
Back
Top