[AccessD] Filter for #2 in SELECT TOP 2 qry criteria

William Hindman wdhindman at dejpolsystems.com
Fri Nov 20 09:56:43 CST 2009


"In (SELECT TOP 1 EventStartDate FROM tblEvents WHERE EventStartDate > 
Date()-10 And EventName = "xyz" ORDER BY EventStartDate)"

I use the above query criteria to derive the current (upcoming) EventID

Now I need to filter for the "next" event, the one that would be added if I 
used "SELECT TOP 2" in the above criteria instead.

Any ideas appreciated.

William 





More information about the AccessD mailing list