Hi All Again
I have a report run based on a query. What I wanted to do was to give the top ten for each record totals.When I changed the query to show the top ten records only one record with its top ten appears in the report. Is there any way around this
Thanks

Brendan Bartley

__________________
Brendan Bartley

Hi,

   As we learned from kindler yesterday:

"What you're looking for is actually a very easy query..."

"SELECT FirstName, LastName, Details.ID, MAX(DatePart("yyyy",[DatePaid])) AS LastPayment
FROM Details LEFT JOIN Payments ON Details.ID = Payments.ID
GROUP BY FirstName, LastName, Details.ID, Payments.PaymentDescription
HAVING (((Details.LastName) Is Not Null) AND (LastPayment<2006) AND ((Payments.PaymentDescription)="membership"));

Please note the syntax:

SELECT [fields], MAX(criteria)
FROM [table]
...

Do you need further assistance? If so, post your current SQL statement.

HTH



mmcdonal

I have tried the code and looking ok at present
Thanks

Brendan Bartley