Calculate Days Between Records

[Gasman]

Worked for me?

Perhaps due to your date delimiters?

If I use yours I get.

So change the code to match your date format.
Could try a universal format?

SELECT tblPayment.PaymentID, tblPayment.PaymentDate, DMax("PaymentDate","tblPayment","PaymentDate < #" & Format$([PaymentDate],"yyyy-mm-dd") & "#") AS PrevPaymentDate, Nz(DateDiff("d",DMax("PaymentDate","tblPayment","PaymentDate < #" & Format$([PaymentDate],"yyyy-mm-dd") & "#"),[PaymentDate]),0) AS [Difference(days)]
FROM tblPayment;

 

[sargon]

You are wright. Now it is working