I see what you're saying...you can limit the records in the options, but
they don't follow through to the spreadsheet, only to the GUI. However you
could add your own Top keyword to the SQL. That seems to work.

--
Tim Zych
SF, CA

"dsharbaugh" wrote in message
...
I am using query in excel to pull in data from an Access database. I only
want 20 results, but the option in xls query is not working when I tick it
and select only 20 records to be included. I don't want to limit the
records
in Access as the source there is used by other xls queries. Is there
something else I have to do to make the xls query return only 20 records?