Tabular Report that looks up row header and column header for query parameters

[Green Biro]

I would like to produce a report that comes out as a table. Each cell of
the table to contain a list of records that satisfy a query involving the
row header and the column header. I'm thinking of lots of subreports but
that might not be that efficient and also I don't know how to make the
report query reference the row header and column header for its parameters.

Can anyone give me any tips to get going, please.

Many thanks.

GB

 

[Green Biro]

I solved this by outputing to Excel and using combinations of the MATCH and
OFFSET functions. Luckily, I knew that there would be a maximum of three
records for any of my 'intersections' so that made this way possible. I
would still like to hear from anyone out there though who knows how to
approach this problem in Access as that way I can set it up for an end user
rather than a techie to run.

Thanks in advance for any insights.

GB