|
| 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
August 24th, 2006, 09:10 PM
posted to microsoft.public.access.queries
|
|||
|
|||
date difference in days
Can you help???
I have a Column called T.StartDate and I would like to calculate the difference in time between then and Now() and have the result returned in days, stored as a variable to use in a further calculation. Cheers. 
|
|
#2
August 24th, 2006, 09:39 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
date difference in days
Have you looked into the DateDiff() function?
By the way, it is rarely necessary or desirable to store a calculated value. You (and Access) have a lot of additional synchronization work to do if you store calculations. Instead, consider using a query to calculate the value on the fly. You can use that (first) query as part of the source in a second query. Regards Jeff Boyce Microsoft Office/Access MVP "InventoryQueryGuy" wrote in message ... Can you help??? I have a Column called T.StartDate and I would like to calculate the difference in time between then and Now() and have the result returned in days, stored as a variable to use in a further calculation. Cheers.
|
|
#3
August 25th, 2006, 01:26 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
date difference in days
Yeah hey man, i know it is not recommended but after i had designed a DB
based on a calculation it was rejected because we want a hard copy of what is on hand so that tables were easily synched between desktop and handheld. I would have preffered it that way... and it was way easier to design as well!! Let me give this datediff() a go! "Jeff Boyce" wrote: Have you looked into the DateDiff() function? By the way, it is rarely necessary or desirable to store a calculated value. You (and Access) have a lot of additional synchronization work to do if you store calculations. Instead, consider using a query to calculate the value on the fly. You can use that (first) query as part of the source in a second query. Regards Jeff Boyce Microsoft Office/Access MVP "InventoryQueryGuy" wrote in message ... Can you help??? I have a Column called T.StartDate and I would like to calculate the difference in time between then and Now() and have the result returned in days, stored as a variable to use in a further calculation. Cheers.
|
|
#4
August 25th, 2006, 04:19 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
date difference in days
You can use a query to "feed" a report. If you include the calculation in
the query, your report gives you the hard copy. No need to create a table to create a report. Regards Jeff Boyce Microsoft Office/Access MVP "InventoryQueryGuy" wrote in message ... Yeah hey man, i know it is not recommended but after i had designed a DB based on a calculation it was rejected because we want a hard copy of what is on hand so that tables were easily synched between desktop and handheld. I would have preffered it that way... and it was way easier to design as well!! Let me give this datediff() a go! "Jeff Boyce" wrote: Have you looked into the DateDiff() function? By the way, it is rarely necessary or desirable to store a calculated value. You (and Access) have a lot of additional synchronization work to do if you store calculations. Instead, consider using a query to calculate the value on the fly. You can use that (first) query as part of the source in a second query. Regards Jeff Boyce Microsoft Office/Access MVP "InventoryQueryGuy" wrote in message ... Can you help??? I have a Column called T.StartDate and I would like to calculate the difference in time between then and Now() and have the result returned in days, stored as a variable to use in a further calculation. Cheers.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
