thanks a lot for your effort lynn, that would have taken me days to even get close to that

I'll have a play with it and I'll reply if I can...

Hi Lynn

Yes, the formats consistent

Good news, it's working again

Bad news, no idea what was the cause of the problem. I took the query and put it in a brand new report, attached to...