OK. Who moved the goalposts while I was not looking?
1) VBA solutions not allowed
2) Now we have the same criteria in two fields that was not in the question

That is exactly what happens in the real world. You find the answer everything works fine and someone moves the goalposts and now it's "Your program doesn't work"
It is fun and I got to think about something else.
Next question Please.
To everyone that had a go Thanks.
Thank you Richard for giving us your time.
Best wishes Alan Hill