How do I use expression formula to calculate two value?

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.

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.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Learn new skill" Learn new wrote in
message
...
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.

Learn new skill wrote:

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
Please feel free to quote anything I say here.