Can I combine my two separate date/time fields ("short date" and .

[jacchops]

I need to calculate time differences (in hours and minutes) across a couple
of days. The database is set up with a separate fields for date and time. Can
I combine these two fields to make a "general date" field, so difference
calculations will be easier?

 

[Duane Hookom]

You should be able to add them together
=[DateField]+Nz([TimeField],0)