Excluding certain values in Access 2003

[Futtecr]

In a query of related tables in a one to many relationship of parent to daughter table. Some parent records will have many daughter table records others will not. How would I formulate a query which can do the following. I want to find out how many patients in the parent table have only 1 record in the daughter table with a certain value. Example: How many patients ONLY had ASD in the daughter table record as opposed to 2 records one with ASD and the next with VSD? I don't want to do this in SQL. Thanks

[June7]

A query is SQL so don't know what you mean by 'don't want to do this in SQL'.

Try an aggregate GROUP BY (Totals) query that generates a count grouping on the patient ID and field containing ASD/VSD values. Access Help has guidelines on building aggregate query with the query designer.

[mrojas]

Could you provide db: Make copy, remove confidential data, run compact & repair, zip?
This way we can be of more help.

[Futtecr]

Due to medical confidentiality issues (as well as shear size of the database), I am unable to provide you with a copy but I can give you a better idea.
Demographics Table has a unique identifier (caseID) and demographic information as well as mortality information. 1 record per patient (about 350,000 records)

One of the daughter tables has a record for each surgical procedure.Of course it has caseID as well. If a patient had an ASD and a VSD repair there would be 1 record for ASD and 1 record for VSD.
Sometimes there are many procedures, sometime just 1. What I would like to do is find the number of patients who have a had an ASD closure (for example) and nothing else. My questions is how to set up a manual query to do that? Thanks in advance

[mrojas]

Rather then trying to create a mock up database, could create a blank database and import into it the table structures of your "live" database?

[mrojas]

A picture is worth...
Not sure if I duplicated the images; first time I use this website's attachment feature.

[June7]

Did you try the suggestion in post 2?