Exclude Question

  • Thread starter Thread starter Brig Siton
  • Start date Start date
B

Brig Siton

We have an Access Database that has the following specs:

1. PatientCase Table
2. Invoice Table
3. Items Table

Each PatientCase record might have multiple Invoice records. Each Invoice
record might have multiple Items record.

What we are trying to achieve is to query a record in the PatientCase that
does not have a specific Item.

For example:

Each Case might have a Phone Call, Fax, Email and Postage items per invoice.

What we are looking for is a case that does NOT have a Postage item in an
invoice.

Any help is greatly appreciated.

Thank you in advance.

Brig
 
well, you could write a query that pulls all cases where there IS a related
item record with a specific item (such as Postage); i'll call it
qryItemCases. then write a second query, using the Find Unmatched Query
Wizard, to find those cases in Patient Case with no matching records
qryItemCases.

hth
 
That is a super-dee-duper-great suggestion.

Now why didn't I think of that? (you don't have to answer this question)

Thank you very much for all your help.
 
you're welcome :)


Brig Siton said:
That is a super-dee-duper-great suggestion.

Now why didn't I think of that? (you don't have to answer this question)

Thank you very much for all your help.
Click to expand...
 
Back
Top