Sorry I seem to have wasted your time and mine!
The page I sent was production page with only one type of coupon, I meant to send you the copy with the problem
I'm using the view rather than the table because of a planned change involving another table.
I've just created a new blank page went through the process of setting up the recordsets and query which worked fine.
Went back to my problem page (copy of the production page) and started to rewrite the query with a couple of parameters
I should have taken a few more screen shots and documented it better.
Or maybe I'm just STUPID
I must say though, between the start and the end of the problem, in the last few days I've had a few JS problems which required deleting the DW cache - who knows!
Thanks again for your persistence