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?
Compare current to previous record in query
- Thread starter 2mutch
- Start date
boblarson
Smeghead
- Local time
- Today, 04:51
- Joined
- Jan 12, 2001
- Messages
- 32,059
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
http://www.access-programmers.co.uk/forums/showthread.php?t=130382
Cosmos75
Registered User.
- Local time
- Today, 06:51
- Joined
- Apr 22, 2002
- Messages
- 1,281
Last edited:
