Good afternoon. I have started working some where where a lot of reports are
in Excel and link to a access database using MS query. This is something I
have not used before although it does look quite simple to use...he says !!

I am trying to create a query to just give the top 100 items (descending
order of sales total between one date and another) and return the results in
Excel. I know in Acess this would be easy by just using the top values. I
have tried doing this in Query by linking to an Access query which returns
all sales but I can not filter the results to the top 100 performing items.
Where am I going wrong

Ps. I have tried using Edit / Options / Limit to 100 records but when the
results are returned to Excel there are hundreds of records.