buisness5119
04-21-2011, 04:07 AM
There is a new article on MSDN that has some useful code samples. This was based off a post by Kerry Westphal on the Access blog a while back. Here is the intro: Many Web 2.0 applications are designed to make it easy to visualize complex data. I found myself recently challenged with this task while working on a project where I wanted to display on a report to show the time elapsed between the current date and another date. Some example scenarios could include how much time has elapsed since a user profile has been updated,Office Pro (http://www.office2010-key.ca/), the time that remains until taxes are due,Office 2010 Home And Stude/nt Key (http://www.office2007key.ca/office-2010-key), or how long a library book has been checked out. I did not just want to show the hours or even days elapsed, but something more in sync with the way I want the information given to me─specifically, that when dates are closer to the current date and time they are represented precisely, and dates and times that are farther away are shown generally. I wrote the ElapsedTime user-defined function to accomplish this task. The function can be used in a query to obtain a string that represents the time elapsed. The string returned is either specific or general depending on the length of time elapsed. For example,Office 2007 Product Key (http://www.office2010-key.ca/office-2007-key), if the date is close to the current date,Cheap Office 2010 (http://www.windows-7-key.co.uk/office-2010-key), it appears as "In 12 hours, 27 minutes". If the date was long ago, it appears as,Office 2010 Pro Plus Key (http://www.office2010-key.ca/), "A year ago". The following screen shot shows the results of the ElapsedTime function when it is used to track items in a calendar. <div