Same Patient, Same Date and Two Procedures

[chuck shaw]

I have a table with three fields:
PatientID (TEXT)
Procedure Date (Date)
Procedure Code (INT) 1 = Diagnostic Cath, 2 = PCI
(Intervention)

A patient may have a Diagnostic Cath Only on a given
procedure date (One Record for that date with a procedure
code of 1) or a PCI Only on a given procedure date (One
Record for that date with a procedure code of 2), or a
Diagnostic Cath AND a PCI on a given procedure date (Two
Records for that date one record with a procedure code of
1 and another record with a procedure code of 2).

I am trying to write a query to select those patients
that had a Diagnostic Cath Only on a given procedure
date. The patient may have had a PCI or Diagnostic Cath
and a PCI on another date. I also want to know those
patients who had a PCI Only on a given procedure date and
those patients who had both procedures on the same
procedure date.

Thanks for any suggestions.

Chuck Shaw

[[MVP] S. Clark]

In a temp table, add all records of those that received the desired
procedure for the desired date.
From the temp table, delete all records of those that receive the other
undesired procedures for the desired date.
--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

"chuck shaw" <cfs...@sbcglobal.net> wrote in message
news:017301c3311c$27519850$a601...@phx.gbl...