Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    22

    Unanswered: Count each time a Field's data changes

    As new Records are added I need to in a Query or Report, count the number of occurrences of several specific Fields that have change from the previous record.
    As a reference point, each Record is unique for Date and Time so if the next Record is added to the DB, I want to know if Field 'x' has changed in value from the entry in the previous Record.
    Specifically, if I there is a change in oxygen concentration from TimeA to TimeB, I want to identify this. The same needs to be identified for numeroous settings and measurements. Basically, all I want to do is to count all of these changes that occur over an 8 hour period.

    Thank you,

    Bill Howard
    Tufts-New England Medical Center
    Boston, MA

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    are these times fixed? Like every hour? it would make sense to keep each value in it's own field.
    Ryan
    My Blog

  3. #3
    Join Date
    Jan 2003
    Posts
    22
    Hi,
    No they are not. As each staff member makes a patient assessment, the time is recorded as 'real-time'.
    Bill

Posting Permissions

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