How do I use expression formula to calculate two value?

[Learn new skill]

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.

 

[Allen Browne]

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]...

 

[Vincent Johns]

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.

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.