Compare current to previous record in query (1 Viewer)

[2mutch]

I have a table of customers who report trouble on their equipment. I would like to compare the date in the current record to the previous record to see if it occurred within 30 days. Can I do this with an SQL query or expression?

 

[boblarson]

I'm going to refer you to a thread that includes some good information by The_Doc_Man. Read his responses carefully and they might help.

http://www.access-programmers.co.uk/forums/showthread.php?t=130382

 

[Cosmos75]

Previous Date & Sum of Month/Year to-date using a correlated subquery

Hope this helps!