Help needed on a query operation

[fortlansing]

I am asked to display this, "List the Client Numbers, Name, and Balance fields in the design grid. Sort the records in desending order by the Balance Field."
AND THIS: "Display the top 25%"

I need to know how to show the top "25%" when I press run, in the datasheet without manually having to arrange them.

I would love detailed instructions ASAP!

 

[pbaldy]

You should do some of the homework. You want to research the TOP predicate in SQL. Also accessible through the query properties.

 

[fortlansing]

I don't get it...

 

[fortlansing]

Nevermind I just figured it out myself, thanks for the clues though!