Search results for query: *

I am working on a report to show the n most used diagnoses in a medical clinic. I need to show the n most used diagnoses for a given reason for visit (RFV). The RFV for each visit is in one table, and the diagnoses used for each visit are in another table, linked by a unique visit ID number...

I'm sorry, Ken - I guess I have not been clear on what I need - I need a report that will look like this - Patient Name A1CDate A1CResult GlucoseDate GlucoseResult Jones, Joe 12/12/01 6.5 1/7/02 75.4 Smith,Mary 11/21/00 7.0 8/9/01 85.9 I can easily...

yes - in the end, there should be 10 columns - a date and result column for 5 different components. In reference to chelseatech's answer - which fields are in the details section? In the first group? In the second group?

The maximum function was my first thought - however, I don't think this will work when I need more than one component ID on the same line, behind the patient's ID - - patient id Hgb date Hgb result Glucose date Glucose result HDL date HDL result - where the date is the most recent...

I am attempting to write a report to show the most recent result for several different lab tests for several different patients at my clinic. The information is contained in a table which has the following fields in each record: - the patient ID number - the result date - the result...

chelseatech - thank you for your answer - most helpful! Ngolem - let me clarify - I am aiming for a list of new patients (patients that are visiting the clinic for the first time). The date parameter would allow me to determine the time period I am selecting these new patients from - say, from...

I have one table which has a patient's name, and another table which contains a record from each time a patient visited our clinic. Each visit record includes the date. The tables are joined via an ID number - the patient table is the "one", and the visit table is the...