Query-Display next time an event occurs

[younggunnaz69]

I am a novice at access and would like help creating a query. Any help is appreciated. Thanks!!



I have a table called Audits where every audit that occurs is logged. Below is a query that will show me every audit that has scored a rating of Needs Improvement or Fail. In this query I would like to make an additional column that will display the very next date this location is scheduled to be audited based on the field AuditDate (fyi-every location has a unique Number assigned called LocNum) There is a chance that a location that receives one of these ratings may not have a future date scheduled

Then I would like a column that calculates the number of days between the 2 dates.

SELECT Audits.AuditDate, Audits.Location, Audits.LocNum, Audits.Rating
FROM Audits
WHERE (((Audits.Rating)="Needs Improvement" Or (Audits.Rating)="Fail"));

[alansidman]

In a new column in your query, create an expression using a combination of the IIF function and the DateAdd Function. Both of these functions can be explained at this site.

www.techonthenet.com

Alan

[June7]

Cross post http://forums.aspfree.com/microsoft-...tml#post928367