THERESA MARIE LOPEZ
New member
- Local time
- Today, 00:33
- Joined
- Feb 21, 2002
- Messages
- 5
I recently separated a field in a query into two fields. For Example:
Originally the field held date and time
such as: 01/31/02 06:30
I changed this by defining two fields in
query as:
Date: Left([OperationDateTime],8)
Time: Right([OperationDateTime],5)
This made data entry much easier for the
operators but now I find that for some
of the reports that need to be generated
from the access database program, the
date and time need to be back together in
one field.
So my question is, Is it possible to
take the two separate field (Date and
Time) and combine them into one field so
that the dates and times would look like
this:
01/31/02 06:30
By the way, I just discovered this
website! Thanks for being here!!! Its
a great resource!
Originally the field held date and time
such as: 01/31/02 06:30
I changed this by defining two fields in
query as:
Date: Left([OperationDateTime],8)
Time: Right([OperationDateTime],5)
This made data entry much easier for the
operators but now I find that for some
of the reports that need to be generated
from the access database program, the
date and time need to be back together in
one field.
So my question is, Is it possible to
take the two separate field (Date and
Time) and combine them into one field so
that the dates and times would look like
this:
01/31/02 06:30
By the way, I just discovered this
website! Thanks for being here!!! Its
a great resource!