Exclude Question

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
 
T

tina

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
 
B

Brig Siton

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.
 
T

tina

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...
 
Top