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

"kevcar40" <kevcar40 (AT) btinternet (DOT) com> wrote

Add a "IN" clause to list all the ops you want to show.

IN ("Op1", "Op2", "Op3", "Op4")

Use the property window of the query designer or enter it the SQL window.