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 TouchToneTommy 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: LMcK07
  • Content: Threads
  • Order by date
  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

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

Part and Inventory Search

Back
Top