G Guest Oct 7, 2005 #1 I want to calculate the difference between two dates in Access. How do I enter the expression formula? I am at the Table Design only.
I want to calculate the difference between two dates in Access. How do I enter the expression formula? I am at the Table Design only.
A Allen Browne Oct 7, 2005 #2 See: Calculated fields at: http://allenbrowne.com/casu-14.html The article explains how, when, and why to create a calculated field in a *query* (not at the table level). Use DateDiff() for the difference between 2 dates. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Reply to group, rather than allenbrowne at mvps dot org. message news:[email protected]...
See: Calculated fields at: http://allenbrowne.com/casu-14.html The article explains how, when, and why to create a calculated field in a *query* (not at the table level). Use DateDiff() for the difference between 2 dates. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Reply to group, rather than allenbrowne at mvps dot org. message news:[email protected]...
V Vincent Johns Oct 7, 2005 #3 Learn said: I want to calculate the difference between two dates in Access. How do I enter the expression formula? I am at the Table Design only. Click to expand... Table Design View won't help much -- you'll need a Query. Define a Query based on your Table. In a field in the Query (in Query Design View), enter something like this: ElapsedDays: DateDiff("y",[MyTable]![Date],Now()) -- Vincent Johns <[email protected]> Please feel free to quote anything I say here.
Learn said: I want to calculate the difference between two dates in Access. How do I enter the expression formula? I am at the Table Design only. Click to expand... Table Design View won't help much -- you'll need a Query. Define a Query based on your Table. In a field in the Query (in Query Design View), enter something like this: ElapsedDays: DateDiff("y",[MyTable]![Date],Now()) -- Vincent Johns <[email protected]> Please feel free to quote anything I say here.
