query top 10 records

[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

 

[Brian]

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

SELECT TOP 10 ......

 

[sg]

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

 

[John Spencer (MVP)]

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.