I have an Access 97 database that gives the difference between a start time and an end time. The column that contains the difference displays as a time with either AM or PM. I have updated my computer's regional settings and have formatted the column in Access to display correctly. When it's published to the web it reverts back to a regular time display with AM or PM.
This is what the columns look like in the Access database.
START TIME END TIME TOTAL
7:59:12 AM 8:04:39 AM 0:05:27
This is what it looks like after it is published to the web.
START TIME END TIME TOTAL
7:59:12 AM 8:04:39 AM 12:05:27 AM
How can I get the total column to display the same format as the one in the Access database after it is published to the web?
Thanks in advance for any assistance,
toniadm
