Apologies in advance if I don't explain this very well.

 

a customer has a ref number for example 12345678. On one table they have multiple records relating to this ref number recorded as 12345678/1 /2 etc etc. For 12345678/1  there may be a record in 2010/11 and 2011/12 and 2012/13 but there may also be a 12345678/2 record for these years too. I need to take the highest /* where the year is 2010/11. there is another table that applies a sequence number to the /* which I can reference if this makes the formula easier.

 

I thought I had nailed this but the report is excluding customers where the highest /* number only exists for a different year than the one specified.

 

Any ideas? I realise this is a jumbly mess so if you need any more information please let me know!

 

Thanks