Totals Max Date Not Working!!!

[Myriad_Rocker]

I select the totals option in my query and put the date at max but it is still returning multiple rows!!!!!!!!!!!!

 

[pbaldy]

Are there other fields with "Group By" other than your date field?????????

 

[Myriad_Rocker]

Yes, I realized that a second ago....so, I queried based on max date and then again to get that other column. Worked like a gem.