[AccessD] Calculating Date/Time

hmm.  I tested it in code only originally.  I just tested it with:

SELECT Contract.[Contract ID], Contract.ContractNum, Contract.Start, 
	Contract.StartWorkDate, Elapsed([Start],[StartWorkDate]) AS Elap
FROM Contract;

and it worked fine.

Here's the output (partial)

Contract ID	ContractNum		Start		StartWorkDate	Elap
45		B40950 000031-2	5/23/2005	6/20/2005		28
day(s), 0 hours, 0 minutes
46		D20163 000032-2	6/7/2005	10/3/2005		118
day(s), 0 hours, 0 minutes
47		D20164 000033-3	9/20/2005	10/3/2005		13
day(s), 0 hours, 0 minutes
48		B40970 000034-2	10/18/2005	10/18/2005		0
day(s), 0 hours, 0 minutes
49		A00000 000000-0	6/20/2005	6/20/2005		0
day(s), 0 hours, 0 minutes

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Wednesday, October 25, 2006 2:59 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Calculating Date/Time


Came out as: 0 day(s), 0 hours, 0 minutes, on all the records.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com