working out difference between 2 dates

[p5x]

I'm trying to work out the difference between 2 dates stored in a table. I want to work out how many days exist between [date1] and [date2] and update the value in another field of the same table.
I can do this using a query but that way (correct me if im wrong) I can't simply show the value in a table.

 

[Vassago]

You can use an update query to accomplish this.

 

[KevinM]

Using DateDiff function in a query is all you need.

If you can see it in the query why do you need to store it in a table (which you should NEVER do anyway)