CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. August 3rd, 2007, 10:31 AM #1
    valkyriex
    valkyriex is offline Junior Member
    Join Date
    Aug 2007
    Posts
    2

    SELECT most recent value

    Hi,

    I'm running a medical report where I need to find patients with BMI value = xx. However, it has to be the most recent BMI reading. That means, if a patient has a BMI reading of xx in March, but yy in June, then that patient should not be included in the report.

    Does anyone know of a formula that can specify such criteria?
    Reply With Quote Reply With Quote
  2. August 20th, 2007, 07:47 AM #2
    Madhi
    Madhi is offline Senior Member
    Join Date
    Jul 2004
    Location
    Chennai, India
    Posts
    1,064

    Re: SELECT most recent value

    Make use of selection formula

    CR.selection formula="not (your condition here)"
    Madhivanan

    Failing to plan is Planning to fail
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured