rows in a crosstab query

K

kevcar40

Hi,
i have a table called op number contain all the ops on the line

I have a crosstab query that returns faults against op number(rows) by
weeks(columns)
problem is it only returns the ops with faults against them

What i want to do is

have all the ops on the lilne returned with and with out fault

how can i do this ?
thanks

kevin
 
P

Piet Linden

Hi,
i have a table called op number contain all the ops on the line

I have a crosstab query that returns faults against op number(rows) by
weeks(columns)
problem is it only returns the ops with faults against them

What i want to do is

have all the ops on the lilne returned with and with out fault

how can i do this ?
thanks

kevin
Click to expand...

probably use an outer join between ops and faults and then base the
crosstab on that.
 
Top