I have attached a really simple db where in a query I'm trying to determine the elapsed time between A sent date and a received date. Can some tell me what I'm doing wrong? Thanks..
Results 1 to 3 of 3
-
3 Star Lounger
- Join Date
- Jan 2001
- Posts
- 294
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2006-02-22 17:45Calculating the elapsed time between 2 dates (Access 2003 )
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Super Moderator
- Join Date
- Jan 2001
- Location
- Redcliff, Alberta, Canada
- Posts
- 4,066
- Thanks
- 2
- Thanked 5 Times in 5 Posts
2006-02-22 17:53Re: Calculating the elapsed time between 2 dates (
Try using the Date diff function:
DateDiff("d",[dateSent],[DateReceived])[b]Catharine Richardson (WebGenii)
WebGenii Home Page
Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2006-02-22 18:57Re: Calculating the elapsed time between 2 dates (Access 2003 )
Or even simpler: just use <code>[DateReceived]-[dateSent]</code>
Set the Format property of the column to the format you prefer.
