Viewing 2 posts - 1 through 2 (of 2 total)
OK, that didn't work as I thought it did. What I want is to report back the whole record, not just the Name and Amount. I also want...
September 26, 2006 at 1:56 pm
#662574
OK! I figured it out! I did this:
SELECT MAX([Table1].Amount), [Table1].Name
FROM [Table1]
GROUP BY [Table1].Name;
Will
September 26, 2006 at 12:56 pm
#662561