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

    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
    Seattle, WA
    are these times fixed? Like every hour? it would make sense to keep each value in it's own field.
    My Blog

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

Posting Permissions

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