How to find number of days between 2 dates in the same FIELD?

[The Sunny Doctor]

I want to how is it possible to find out days between 2 dates in one field.

Eg.

[Sales Made On] is a date field with following values:

10/10/2004
10/15/2004
10/19/2004

How can I find the days lapsed between 2 consecutives values in the above
given field?

Thanks.

 

[Duane Hookom]

Try:
SELECT *,
[Sales Made On] - (SELECT Max([Sales Made On])
FROM tblA A
WHERE A.[Sales Made On] < tblA.[Sales Made On]) as Difference
FROM tblA;