MSQUERY...My Exact question (Excel 2000)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Once you are in MSQuery, click the SQL CommandButton.
Edit the query and insert TOP 100 right after SELECT
MSQ says it can't show the query, but you can save and return to Excel

HTH
 
Back
Top