|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 24th, 2005, 05:57 PM
|
|||
|
|||
Can I combine my two separate date/time fields ("short date" and .
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? 
|
|
#2
January 24th, 2005, 07:59 PM
|
|||
|
|||
|
You should be able to add them together
=[DateField]+Nz([TimeField],0) -- Duane Hookom MS Access MVP -- "jacchops" wrote in message ... 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Import Date Fields | Otto | Contacts | 1 | December 2nd, 2004 04:26 PM |
| Data entry form using two tables | cursednomore | Using Forms | 8 | November 30th, 2004 07:05 PM |
| Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
| Date form fields in Word 2003 | Andy | General Discussion | 1 | November 11th, 2004 11:06 AM |
| Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |
Linear Mode
