Hi all

I am trying to create a join query (recordset) in excel dao, which is essentially made up of two queries.

This recordset works fine, But I only want to return the Max [frDate] for each of the EmpNo's.

Please Login or Register  to view this content.
If I write standard sql and only select the EmpNo and the frDate i return the correct records, just not all the fields.

This returns just the Max frDate for each EmpNo.

Please Login or Register  to view this content.

This is my attempt at combining the two (but obviously not working), just trying to explain fully.

Not Working:
Please Login or Register  to view this content.
Hope this all makes sense... any help appreciated.

Thanks