Date/Time

Table has a field named TIME.
Datatypeate/Time
Format: 09/12/2005 6:24:45 in 24 hour format

Want to have a field, named TIMESUB that substracts TIME by 7 hours using
query.
Example: 09/12/2005 6:24:45 substracted to 09/11/2005 23:24:45

Thank you

You can use the DateAdd() function to define a column in a query that is 7
hours earlier than an existing datetime value.

--
Duane Hookom
MS Access MVP


"Jay" wrote in message
...
Table has a field named TIME.
Datatypeate/Time
Format: 09/12/2005 6:24:45 in 24 hour format

Want to have a field, named TIMESUB that substracts TIME by 7 hours using
query.
Example: 09/12/2005 6:24:45 substracted to 09/11/2005 23:24:45

Thank you

In addition, I would recommend chaging the Field name TIME to something
else.

"Time" is a reserved word for function Time() as well as the Time statement.
Using "TIME" can cause undesirable results if you are not careful when you
do VBA code later.

HTH
Van T. Dinh
MVP (Access)



"Jay" wrote in message
...
Table has a field named TIME.
Datatypeate/Time
Format: 09/12/2005 6:24:45 in 24 hour format

Want to have a field, named TIMESUB that substracts TIME by 7 hours using
query.
Example: 09/12/2005 6:24:45 substracted to 09/11/2005 23:24:45

Thank you