Please could you advise if I can query data in a ROW? For example I have a
name, followed by reasons for non-attendance for many weeks, eg Y (for yes)
AL (annual leave) etc and want to be able to count the Ys etc for each
person. Thanks a lot.