Time difference between rows

[GeirA]

Hello

I have an Access database:

ID Maint_Date
1 16.11.2011 13:13:32


2 17.11.2011 14:35:00
3 20.11.2011 16:45:00

I would like to calculate (in SQL) the timedifference, in minutes, between each rows.

I have absolutely no clue how to do this - can someone please help me?

[pbaldy]

http://allenbrowne.com/subquery-01.html#AnotherRecord

[GeirA]

Ahhh - subquery..

Thanks a lot!!!

[pbaldy]

[pbaldy]

No problemo!