Recording date and time together

[Shelby]

How can I format a field in a table to record both the
date and time? I need to be able to calcuate the
difference between two date/time entries.
-Shelby

 

[kevin watkins]

Shelby,

What you need in the table is to format the date/time to
be general. this will give you the date and time. Then
using the right syntax you can calculate date/times. This
syntax is best explained in the help for access. The
expresion builder has all the proper syntax to use when
building the criteria in the query. Date time strings can
be rather lengthy since you have to specifiy the correct
portion of the date/time field to run the calculation on.

Kevin

 

[Shelby]

i must be doing something wrong, because I tried
formatting it that way, and couldn't get it to show both
pieces. I'll play with it a little more. Thanks!

 

[John Vinson]

How can I format a field in a table to record both the
date and time? I need to be able to calcuate the
difference between two date/time entries.
-Shelby

Use a Format of "Long Date", or a format which includes both date and
time portions such as

"dd-mmm-yyyy hh:nn:ss"