These are different coupons (tcs, lpl, ptp) and each line underneath relates to the coupon and shows what lines have been played for that coupon e.g. the customer has played lin01 & lin02 of cpn lpl, customer has played lin02 & lin04 of cpn type ptc etc.
What I need is a way of running a command button (for example) that will run through the whole table and give me a count of coupon "ptp" which just have "Lin04" assigned to it. In other words how many customers have played the coupon type ptp and have played a Lin04.
Due to the sheer volume of data, restructuring could be a problem and extremly time consuming. I could always filter the data by "ptp" within access but I would lose all the line info associated with them. Unless of course you can advise other ways??