Search results

I need to create a report with the max date, Title (in OPs example, this was her Address field), and also include several other fields. When i add other fields, it stops grouping correctly. I tried creating a query from the query and adding additional fields, and grabbed the fields I needed...

OMG! THANK Y'ALL SO MUCH!!! i've been trying to do this for so long - my company is gonna LOOOVE me! wish i could buy y'all a drink!!! i've always lurked and found the answers i need, but i'm sure i'll be posting more cuz the boss always wants more more more!!! job security :)

this is what i'm doing - only using the necessary fields. do i put "MAX" (for the oldest date) i the Group By cell, or in the Criteria cell? nevermind - i just read the previous post. ty! trying it now...

I hate when people write the "forgive me in advance for dumb question", but please fogive the stupid question... What would be the criteria/speicific info to query for latest date if I did it this way?

I am trying to create a query very similar to what the OP described. When I follow the instructions for the Group By query, the Design View still shows each row/line item, not just the oldest date. Is that what it is supposed to show? then do I somehow filter the information in the report?