What do I use for this querie?

  • Thread starter Thread starter James
  • Start date Start date
J

James

I am using Access 2003 and I am trying to get all the colors that are
not shipped by supplier S1 using a querie?


Thanks for your support.


James
 
Without any info on your tbl structure...
you might try something like this:

SELECT Table1.Supplier, Table1.Color, Table1.Shipped
FROM Table1
WHERE (((Table1.Supplier)="S1") AND ((Table1.Shipped)
=False));
 
I am using Access 2003 and I am trying to get all the colors that are
not shipped by supplier S1 using a querie?
Click to expand...

Without knowing anything about the structure of your tables, I can't
be very precise - but you should be able to use a subquery to do this:
SELECT Color FROM colortable
WHERE ColorID NOT IN(
SELECT ColorID FROM Shipments WHERE Supplier = 'S1');
 
Back
Top