Report help

[sonny]

I have 2 queries for 2 reports. Id like to combine them.
Heres how they are:

qry1: Employee, Project title, RecordID, Status
qry2: Assigned Employee, Task, RecordID, Completed

What Im trying to do is show what each employee has on thier plate.
Only one employee is responsible for each project but they may assign other employees a task to help them. So, a employee can be tasked many times on the same project. (my qry2 for tasks only report if its not completed)

Right now the qry1 looks ok in the report because I have it grouped by employee. So does the qry2. But I cant figure out how to show the tasks without taking up half the page doing a subreport.

Current layout of qry1 Example:

Employee1 Name
RecordID Project title Status
RecordID Project title Status
RecordID Project title Status
Employee2 Name
RecordID Project title Status
RecordID Project title Status
RecordID Project title Status

Id like to put the tasks they may have at the end of the main projects thier working on, if any. Kinda to look like this:

Employee1 Name
RecordID Project title Status
RecordID Project title Status
RecordID Project title Status
Tasks: RecordID Task

Any ideas would surely help!

 

[Len Boorman]

Are your tables normalised ?
What significance is the RecordID that appears in each query.?
Do associated records from query 1 and quer2 have the same RecordID value ?

L

 

[sonny]

Yes, the recordID gets picked up when a task is created and then matches the other tbls recordID. But both reports are grouped bt employee. I need to show the main projects they have assigned and tasks below this list.

 

[Len Boorman]

It looks then as if you should be able to create a further query that take the existing two queries as its source linked using the RecordID.

This final query to be used as the source of a Report in which you can sort by Employee and Group by Project with Tasks in the Detail.

len