Recent content by nerthol

Hi You are right grouping is not needed. Noticed that after I posted. Thanks for helping out. Yes ranking sales reps for most sales per month.

Thank you very much both of you! I kept getting all of the 5 records returning and not just the one I needed. So from the pointers I used: SELECT TOP 1 table1.[Sales Rep], Sum(table1.[Total Sales]) AS SumOfTotal FROM table1 GROUP BY table1.[Sales Rep] ORDER BY Sum(table1.[Total Sales]) DESC...

Hello All, I have searched for this and failed.:banghead: I have a query which is a max sum of sales for several sales reps. (If that makes sense?) Sales Rep, Total Sales 1, £100 2, £200 3, £500 4, £50 5, £150 I need to create a report which delivers the sales rep with the most sales and...