Help finding unique patients

[Blue Dolphin]

Hi,

Could you help find the number of UNIQUE patients that took the drug "Zidovudine"? I know the answer is 3 because i manually counted the patients, but how can this be programmed. I would like to know the unique number of patients based on a search for any drug.

I attached my small file. The account name is admin and has no password. Thank you so so much.

testing_unique.zip

Edited September 5, 2007 by Guest

[LaRetta]

You are missing a Patients table.

[comment]

And a Drugs table, I would add.

[Oldfogey]

Even without the missing tables, the question is still valid.

I presume that 'Patient ID' is unique to a patient and that you have a Patient table with one record per patient?

Another guess, based on the title of the layout, is that there are multiple patient/drug records. Correct?

If you set up a layout in your patient table with a Drug field from this Interval_History table and do a find for the particular drug, you will find just those patients who have that drug in the Interval_History table. The number will show up in the status area. If you want to script it all, use Get(FoundCount) to display the number of patients.

[Blue Dolphin]

Hi,

Yes, that is correct. I have a patient table and there are multiple patient/drug records with different dates. Is there any way to perform the search for unique patients taking a particular drug on the Interval_History table? The reason I ask is because I have 20 tables similar to the drug table in which the user would like to search on any field in any table and get the # of unique patients for that search.

[Blue Dolphin]

yes i have the drugs table but did not add it to the prototype

[comment]

I have a patient table ... i have the drugs table

Well, then it should be very simple - see the attached.

I have 20 tables similar to the drug table in which the user would like to search on any field in any table and get the # of unique patients for that search.

That I did not understand, and it doesn't sound good.

Prescriptions.fp7.zip

[LaRetta]

Yes, good example file, Michael!

Now I would have just required a Patient table. Then, from the Interval table, perform a find for the drug (in this case Zidovudine) and then GTRR (Go To Related Records) to the Patient table for a list of unique patients - this would be the key to producing a unique list of Patients using this method.

Your portal setup and proper drug structure offers the best of all worlds. :wink2:

[comment]

Sure, it's even possible to get it from the Prescriptions table alone - but why work hard?