M
mogll
I have a dbase to track internal audits by facility. In the audit report, I
have the audit date field shown, but also want to add a field to display the
prior audit date for that specific facility. I have tried doing this with a
query, but no luck. My data looks like this:
AuditID SiteID AuditDate
30 10 1/8/09
23 10 3/6/08
15 10 2/5/07
29 11 1/2/09
17 11 2/6/08
14 11 6/8/07
10 11 9/7/06
Any suggestions will be greatly appreciated.
have the audit date field shown, but also want to add a field to display the
prior audit date for that specific facility. I have tried doing this with a
query, but no luck. My data looks like this:
AuditID SiteID AuditDate
30 10 1/8/09
23 10 3/6/08
15 10 2/5/07
29 11 1/2/09
17 11 2/6/08
14 11 6/8/07
10 11 9/7/06
Any suggestions will be greatly appreciated.