Top Ten Customer

[helmi]

I wanna create a query showing only the top ten customer(which means not more than ten records).
How do I do it?

 

[GHolden]

You need to use TOP 10 and ORDER BY in your query SQL.

eg.

SELECT TOP 10 tblCustomer.ID FROM tblCustomer
ORDER BY tblCustomer.ID

This would select the top ten customers based on Customer ID
There are two ways to write error-free programs; only the third one works.

 

[danvlas]

Add a Top 10 immediately after the Select word:

Select Top 10 FieldList From...

Or...in your query properties, set the Top Values property to 10 (or whatever)...


Good luck


Daniel Vlas
Systems Consultant