var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query: exclude
Hi, I am trying to write what seems like a fairly simple query in Access but not finding it in any help in the "help" file.
For any record where the STATUS field = "canceled" I want the query to exclude that record, and all such records with that CUST.NUMBER.
This is probably a newbie question...thanks!
where status <> 'canceled'
and custnumber not in
( select custnumber
where status = 'canceled' )
Last edited by r937; 11-09-06 at 12:39.