Bring the 10 bigger values

[gatarossi]

Dear all,

I have to do a consult, and I need to sum the values for each
customer... then I need that the consut return only the first 10
bigger customer in values...
I have the fields customer code and values in my table.

How can I do it?

Thans a lot!!!

André.

 

[Beetle]

You can use a top value query to do this. You will find info on how to create
one at this link;

http://support.microsoft.com/kb/304356


HTH