Date/Time conversion

[Nick I]

Hello, I have a table that has two fields. One field is a Date field,
formatted as a Date. The other field is a time, formatted as an integer. Here
is some sample data from this table:

Date Time
3/21/2006 1000
3/21/2006 1200
3/21/2006 1430

I need to create a third field to have the Date/Time formatted as a
Date/Time. For example, with the data above, a third field would read:

3/21/2006 10:00 AM
3/21/2006 12:00 PM
3/21/2006 2:30 PM

I would like to just create a query and create the third field in there. Any
ideas how to do this? I'm at wits end. Thanks!!!

Nick

 

[K Dales]

An expression like this should convert it:
DateTimeField:[DateField]+TimeValue(Format([IntTimeField],"00:00"))