Subtract a column field

[captnk]

I need to be able to subtract fields in a column from each other.
eg

[date] [expected answer]
27/12/99 9
18/12/99 16
2/12/99 14
18/11/99 12
6/11/99

(The answer being the difference in days between each date)

Its easy in a spreadsheet,but I need the programme to be self contained.

The other thing I have looked at is using the access spreadsheet in a form,but I have no idea how to get the table/form data into it (or back) for that matter.
Any help appreciated

Regards

 

[Rich]

You need the DateDiff and PrevRecVal /NextRecVal functions, although you'll have to decide the order first.
There is no spreadsheet in Access only a Crosstab which you cannot enter data into, unfortunately.