Find Record with date before Current Record

[mrmims]

Hello,

I am wracking my brain on this one, and it is probably easy.

I have a list of Load Tests (LoadTestID) done on pieces of equipment (AxisID). Multiple Load Tests on one piece of equipment. Each LoadTestID has a Date (DateofTest).

How, in a query, do I show all Load Tests performed on an Axis, the date it was performed, and the number of Days between Load Tests on the same equipment.

1) Axis 73 2/13/15
2) Axis 73 4/23/15 69 Days Between Tests


3) Axis 73 6/01/15 39 Days Between Tests
4) Axis 73 9/21/15 112 Days Between Tests

Thank you in advance for any kick in the right direction.

[pbaldy]

One way:

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