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
 
Ad

Advertisements

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

Advertisements

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.
 

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 97 VB 1
Access 97 VB 2
Access 97 to XP VB error 0
Access 97 1
Access 97 1
access 97 1
VB in Access 2
Access 97 to Access 2000 3

Top