I realize this is stretching the topic a bit....please indulge me
I have an Airplane AAL1987 in the "Airplanes" table.
I have Criteria that airplanes meet in the "Criteria" table.
Theres a nicely functioning 1(Airplane) to many (Criteria) relationship established.
I also have Prompts that the airplanes say in the "Prompts" table.
Theres also a nicely functioning 1(Airplane) to many (Prompts) relationship established.
I have a query that essentially mulltiplies the Criteria recs and the Prompt recs of each airplane (3 different Criteria and 2 different Prompts results in 6 recs in the query)...
What I'm unable to accomplish is a report that looks like this:
The "grouping" wants to place all the prompts w/ every Criteria. So Airplane 1 above would show all the prompts twice for instance. OR ..... the grouping shows only 1 Criteria & each of the Prompts only once........very annoying
I'd like the report to show 2 independent groups for each airlpane....
Hmmmmmm........a "Union Query"?