Tags or Flags????

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a ton on invoices. Some of those invoices have a
certain item on them. I want to grab only the invoices
who have the item I'm looking for. I need to see the
whole invoice. I'm new to Access. Any help is greatly
appreciated. Thank you. ~John
 
Hard to say without knowing your structure.

Assuming a more or less normal structure, you could use a subquery to identify
those invoices that have a specific product. That would look something like:

SELECT Invoices.*, Details.*
FROM Invoices INNER JOIN Details
On Invoices.InvoiceNumber = Details.InvoiceNumber
WHERE Invoices.InvoiceNumber IN
(SELECT tmp.InvoiceNumber
FROM Details as Tmp
WHERE Tmp.ProductID = "abc123")
 
Back
Top