Search results

  1. J

    Query with Date Range and Duplicates

    Hello, I'm looking for the best way to create a query using two tables. One table has patient ID, diagnosis date, and diagnosis. The second table table has patient ID, lab value, admission date and discharge date. I would like to create a new table that shows the patient ID, lab value and...
  2. J

    How to Remove Characters but Keep Decimal Point in MS Access Field?

    I currently have a very large data set and I would like to remove all of the characters in the results field but keep the numbers and decimal point. What is the best way to do this? Here is an example of what the result field looks like: 52.4,*,H 102.9,*^,H 34.5,*,H 30.9 >150.0,*^@,H 82.1,*,H...
Back
Top Bottom