query top 10 records

  • Thread starter Thread starter sg
  • Start date Start date
S

sg

Hi,

I'm trying to create a query to only show top 10 sales account information
sorted by sales descendingly.
account, name, sales.
How can I do this? I tried having count("account")=10 , it doesn't work.

Thanks in advance,
Sarah
 
sg said:
Hi,

I'm trying to create a query to only show top 10 sales account information
sorted by sales descendingly.
account, name, sales.
How can I do this? I tried having count("account")=10 , it doesn't work.

Thanks in advance,
Sarah
Click to expand...

SELECT TOP 10 ......
 
Hi Brian,

That works, thanks so much. By the way, is it possible for user to set
number of records? like replace 10 to a variable?

Thanks,
sarah
 
No, that is not possible.

You would need to build the query in VBA to do this.

Well, I guess I should say, As Far As I Know it is not possible.
 
Back
Top