Join? problem

FRED_EMMERICH_(Guest) · Post by **FRED_EMMERICH_(Guest)** » Wed Sep 25, 2002 9:59 am

I have 3 tables in a .mdb. It would be a one->many->many join. In the second table, there is a date field which I sort on. I only want the latest date record to be used. I am not sure if this is a join issue, but in my second join I get all the records for the third table for each record in my second table. I would like to have only the latest date record used. How can I keep the others out? I tried a counter but it counts composite records and gives the wrong answers.____thanks