M
Mike Dinnis
Hello,
I have a query returning all available salespeople and a query showing
performance for salespeople. What I would like to be able to do is return a
new query showing all salespeople and their associated performance where it
is available (some may not have any data as they were on holiday etc.)
Would I be best to use a Union query and then group the results of this or
is there a more efficient way of doing this?
If need be I can go back and re-do the original queries, but I keep getting
a report with only the salespeople who have actually sold something in the
time period specified and I require them all to be shown (sort of nudging
them a bit to say 'hey, why don't you sell something!').
Cheers,
<M>ike
I have a query returning all available salespeople and a query showing
performance for salespeople. What I would like to be able to do is return a
new query showing all salespeople and their associated performance where it
is available (some may not have any data as they were on holiday etc.)
Would I be best to use a Union query and then group the results of this or
is there a more efficient way of doing this?
If need be I can go back and re-do the original queries, but I keep getting
a report with only the salespeople who have actually sold something in the
time period specified and I require them all to be shown (sort of nudging
them a bit to say 'hey, why don't you sell something!').
Cheers,
<M>ike