Access 97 VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to compare the latest record in a database (selected by date),
comparing 5 numeric fields with the previous record's same 5 fields to see if
there has been a change of more than 15 decibels (selected by date) in two
consecutive fields. Could one of you geniuses please help me with the code
for this.

Much appreciated, as always
 
Open your table as a recordset in descending order by date. Then, the first
record will be the most recent date. Set some variables with the data from
the fields you want to compare. Then MoveNext and that will be the previous
record by date. Now compare your fields to the variables.
 
Thanks!!
--
Nigel Forge
User Support Analyst


Klatuu said:
Open your table as a recordset in descending order by date. Then, the first
record will be the most recent date. Set some variables with the data from
the fields you want to compare. Then MoveNext and that will be the previous
record by date. Now compare your fields to the variables.
Click to expand...
 
Back
Top