Access 97 VB

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
 
G

Guest

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.
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Compare records in same access table 0
Access 97 VB 1
Compare records and reset 2
Adding values in two feilds based on condition 1
Need Help with SQL statement - "Insert Into" 7
Compare 2 Tables 1
Access 97 => 2003 5
Holiday - Error 4

Top