Query not producing the desired data

[WAVP375]

Attached is a query and the results as well as the desired results. I need some direction to obtain those desired results. If they are not attainable in the query, how can I use the produced data to generate a report with only the data desired? Any help will be appreciated.



Thanks

[RuralGuy]

I can't tell from the Relationship picture *how* you have those tables Joined. Maybe if you show us the SQL for the query we'll have a better understanding.

[June7]

Your desired output does not show the combination of 101 with 1023 as reflected in the actual data. Why would you not want to show this data combination?

[WAVP375]

Course 101 is required for both 1016 and 1023 jobs. The student takes the course only once therefore it wants to be displayed only once.

[WAVP375]

SQL attached

Thanks

[June7]

You will have use report Sorting & Grouping features.

[WAVP375]

I can group on Job and I can group on Course but not both at the same time.

[June7]

Sorry, that does not make sense to me.

There can be multiple levels in grouping.

What you want might require subreports.