The Underscore Archives

i'm getting bizzare results from a simple SQL query in MS Access:-

if I do something like:-

SELECT TOP 10 foo_id, foo_name, foo_modified from tbl_foo

I get back ten rows as expected,

however, if I attempt to order the results by foo_modifed (date/time field)
I get back *all* the records, not just 10.

i.e.

SELECT TOP 10 foo_id, foo_name, foo_modified FROM tbl_foo ORDER BY
foo_modified DESC

returns sometimes *thousands* of records

can anyone explain this? FWIW some of the foo_modified fields are null and
i've tried filtering e.g "where foo_modified is not null"


-- 
Rick Hurst, Web developer, Bristol, England
http://www.rickhurst.co.uk | http://www.netsight.co.uk