rows in a crosstab query

[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

 

[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

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