I understand the concept of a cross-tab query, however, I don't see how it can be applied in a case where you don't know the number of related records. ...

Thanks for the replies. I'll put them to the test when I get back to the office next week. This week I'm in a training course.

Hi, Jeff. ...