Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: whimple
  • Content: Threads
  • Order by date
  1. whimple

    Use of top N sort

    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...
  2. whimple

    FInding most recent date/result

    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...
  3. whimple

    Finding "firstimers"

    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...

Part and Inventory Search

Back
Top