Access 07 - Confused while trying to create a report

[DomZ]

Hey guys,
Been a while since i've posted here. Things have changed since! hehe

Well i'm using Access 2007 and i'm trying to do the following

I have a general query that feeds from a table (in that table there's a uniqueID for every row) - Lets call it Query1
I have 3 other queries that "feed off" that query that is, the uniqueID is used in the WHERE clause. - Lets call them Query2, Query3, Query4

How can I create a report so that I have Query1 as my main, and the uniqueID of that query is passed to Query2, Query3 and Query4 as a "sublevel" of Query1?

Note: Query2, Query3 and Query4 return more than 1 rows hence why I cannot process it as JOINS.. i wouldnt want to have Record1 Appearing X number of times

Thanks

 

[HiTechCoach]

Hey guys,
Been a while since i've posted here. Things have changed since! hehe

Well i'm using Access 2007 and i'm trying to do the following

I have a general query that feeds from a table (in that table there's a uniqueID for every row) - Lets call it Query1
I have 3 other queries that "feed off" that query that is, the uniqueID is used in the WHERE clause. - Lets call them Query2, Query3, Query4

How can I create a report so that I have Query1 as my main, and the uniqueID of that query is passed to Query2, Query3 and Query4 as a "sublevel" of Query1?

Note: Query2, Query3 and Query4 return more than 1 rows hence why I cannot process it as JOINS.. i wouldnt want to have Record1 Appearing X number of times

Thanks

A simple ways to handle this is to use sub reports to print the data from Query2, Query3 and Query4. Use the uniqueID field for the master/child linking field property of each of the sub report controls.

 

[DomZ]

Yea, i've created a report using the wizard and i added a subreport to it.

Now when i have both linked the master and child fields from Query1 and Query2, when i preview 10records from the report, the subreports shows all the records from Query2...

Am I missing something?

 

[HiTechCoach]

Yea, i've created a report using the wizard and i added a subreport to it.

Now when i have both linked the master and child fields from Query1 and Query2, when i preview 10records from the report, the subreports shows all the records from Query2...

Am I missing something?

Are you sure that the field that you want to link with from Query1 has the matching field add into Query2. If the linking field is missing from Query2, then Acxess will normally show all the records from Query 2.

 

[DomZ]

I can guarantee you, even so that the wizard choses the fields for me... haha