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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LMcK07

  1. LMcK07

    ToNumber rounds instead of preserving decimal place

    I'm using CR XI Prof and hit a strange issue converting a string field to a number so I could calculate an average. The string field "Lab.Value" has one or two characters (always digits), a decimal, and another character/digit - e.g., 7.3 or 10.8. Using both ToNumber and CDbl, the result...
  2. LMcK07

    Evaluating data w/ two different criteria

    Thanks so much. I've been working on this again since Friday morning and still kept getting a handful of duplicate patients, but just this minute I realized that some patients get multiple BP readings in one visit. So I queried just for "right arm sitting" BP and it's perfect. Thanks again LMcK
  3. LMcK07

    Evaluating data w/ two different criteria

    I'm querying an electronic health record to determine the % of patients in which blood pressure is controlled. The threshold for "control" for diabetics is a systolic BP of 130; for non-diabetics, it's 140 - so I need to classify the patient as diabetic or not before evaluating the BP value...
See more

Part and Inventory Search

Back
Top