Can we use the datediff function and put the answer in a cell?

  • Thread starter Thread starter timmone
  • Start date Start date
T

timmone

what we want to do is return the difference of this function into a cell in a
table, can we do it?
 
On Sat, 12 Dec 2009 11:34:01 -0800, timmone

Yes, but you shouldn't. Because that would violate an important
relational database design principle that says "no calculated fields
in the database". Rather you would calculate the value on the fly in a
query:
select DateDiff("d", myStartDate, myEndDate) as DaysBetween
from myTable

-Tom.
Microsoft Access MVP
 
Back
Top