select from mutiple queries

[sandhurstUK]

Hi guys,

I have a table, in which is stored the names of my team members, location of work to be done, date work due, and a numeric value relating to the amount of work outstanding.
I have created qrys which select the team members and the work they have outstanding by setting criteria such as <date()-30, <date()-60, <date()-90 etc etc. where the number relates to the amount of days the work is outstanding. These qry's run fine on their own and show the correct data.

I want to be able to chart this data for the full team to show by team member how much work remains in each date range. The problem is, that not all team members have work outstanding in all ranges.

When I group each of the qrys together into one qry, with the qry relationship set to link by team member name, all I get is the data for those members with work outstanding in all date ranges. Therefore if a team member only has work in in say two of the preset ranges it does not show him at all.

Very frustrating !!

Here's hoping guys !

 

[David R]

Try changing your relationship join to either left or right, depending on which side you want to see 'all' of. Rightclick on the join line and select 'join properties' to see these options.

HTH,
David R

 

[sandhurstUK]

David,
I have tried this solution already and it does not work. I think my problem is the collection of data via the sub qrys, because if it's not there in the first place, then it will never be there when I join the qrys together.

Perhaps I may need to be looking at querying the host data table and then using expressions in the QBE grid fields to select the ranges I need to display (ie 0-30 days 30-60 days etc), but I am not sure of how to go about it.

Thanks anyway.