Combining reports into one

[stephen81]

I have two seperate tables, say table x and table y and I want to produce a report containing information from both. Table x has a list of targets each belonging to one a group either A, B, C, D, E or F. Table y has a list of Actions each also corresponding to a group A, B, C etc. I want to produce a report grouped as follows.
xA, yA, xB, yB, xC, yC etc. ie. all the targets in section A followed by all the actions in section A followed by all the targets in section B, followed by all the actions in section B. Does anyone have any idea how to do this?


Stephen

 

[simongallop]

Create a query show the 2 tables link by group and select group target and actions. Now use this as the feed for your report