rows in a crosstab query

  • Thread starter Thread starter kevcar40
  • Start date Start date
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
 
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.
 
Back
Top