G
Guest
Could I please ask for help on the following: I have created the code as far
as to open a recordset of data from a table, sorted by username and date of
test. (The table contains records of hearing tests for about 200 users and
will grow quite large over the years). A field called 'baseline' which is a
yes/no is set as Yes for the first record by default. -- I now need to run
code that compares all the future tests for each user and if the field called
'Status' contains two CONSECUTIVE records with 'Abnormal Shift' I need to
reset the field 'Baseline' in the most recent record of the pair to Yes and
change the previous record (wherever that may be, as the position may well
change in the future) back to 'No'.
Any help is much appreciated
Nigel Forge
as to open a recordset of data from a table, sorted by username and date of
test. (The table contains records of hearing tests for about 200 users and
will grow quite large over the years). A field called 'baseline' which is a
yes/no is set as Yes for the first record by default. -- I now need to run
code that compares all the future tests for each user and if the field called
'Status' contains two CONSECUTIVE records with 'Abnormal Shift' I need to
reset the field 'Baseline' in the most recent record of the pair to Yes and
change the previous record (wherever that may be, as the position may well
change in the future) back to 'No'.
Any help is much appreciated
Nigel Forge