Report/Query design issues

[J.Windebank]

Sorry for posting this in the General forum, but as this directly relates to both Reports and Queries, I figured this was preferable to posting the samer thing twice in other forums.

OK, here is the problem, I just cannot seem to get my head around how to design a query and then how to produce the query results in a report.

I originally posted about the query in this thread but it was not as easy as I had hoped.

I cannot work out how to get the unmatched query to find the data I am after.

I need to find all records that existed in COTRound "a" that did NOT exist in COTRound "b". This has me utterly stumped.

All the query is working out is what what has been added from one week to the next.

I then also need to produce a report, that shows:

Monday:
- [Query result 1 where Day = "Monday"]
- [Query result 2 where Day = "Monday"]
- [Query result 2 where Day = "Monday"]

Tuesday:
- [Query result 1 where Day = "Tuesday"]
- [Query result 2 where Day = "Tuesday"]

And so on for all seven days.

I thought subreports would work for this, but will they dynamically arrange themselves on the report to allow for more or less records being displayed from the query?

As you can all probably tell, I can't quite work out how to design this whole thing, and it is driving me insane. Any and all suggestions will be most welcome.

Thanks,

Jordan

 

[bjackson]

have you tried creating the query using the
find unmatched query wizard

 

[J.Windebank]

What I tried was creating one query for "round a" then one for "round b" and di an unmatch query using the wizard on the two of them.

Unfortunately it always came back with no records.