date difference in days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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!
 
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
 
Back
Top