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