Notifications
Clear all
Topic starter
I have an Excel file containing two columns - patient name & ddate (different for each patient). I would like to create a report for only patients whose names are in the Excel file and use the ddate in the Excel sheet to find all visits and latest observation terms within one year from the ddate.
eg patient XXX ddate – 7/27/2011
I need to list all office visits the patient had from 7/27/2010 to 7/27/2011. Also I need to list certain observation terms like BP, AIC, etc between this period. How can this be done?
Can anyone please give suggestions. Thanks in advance.
Posted : February 26, 2013 1:32 am
Use the following tables:
PERSON.searchname
OBSHEAD.name
OBS.obsdate
This should at least get you on the right track...
Posted : March 6, 2013 10:22 pm
