I have a query that is complex and runs great. The query displays the results from a cash payment table for individual customers. If a customer as 12 rows of payments (one for each month of the year), then all 12 show up in the result of the query. What I want is the latest paydate to show up. When I try to do the Group By, and elect my PAY_DATE field, it doesn't work.