filter a query further

[109bow]

I have a query which lists data for 86 different units. I need to get the query to
return the last entry for each position on each unit, based on turn date. There should be 16 positions for each unit. Then I need to be able to create a report based on the query for just one unit or for all 86 units. I have attached a zip file of how far I have got. I've been stuck on this for ages, so I'm hoping someone can help!

 

[neileg]

It would be easier to help if you hadn't password protected the file.

 

[109bow]

Sorry, I wasnt aware it was password protected

 

[neileg]

It's not, it's a problem at my end! We've just migrated to active directory...