I'm having a very frustrating problem...I've got two pages, each of which are
supposed to do basically the same thing, but from two different tables. Both
use SELECT TOP n in the SQL statement to get only a certain number of
records. One of them works (only returns 3 rows) and the other does not
(returns all rows)...I don't get it.
This one works:
"SELECT TOP 3 lngID, strName, datDateStart, datDateEnd " &_
"FROM Events " &_
"WHERE bitHide=False AND datDateShowAsOf <= #" & Date & "# " &_
"ORDER BY datDateStart;"
This one doesn't:
"SELECT TOP 3 lngID, strName ...