Jonathan,
You really should have a autonumber key field for each record.
In this example, I'll use your numbers (6, 7, 8, etc) as if it were
the [SampleID]
Your Date field "appears" to be providing that uniqueness, but
there's always the possibilty of problems with that...
This is just the "concept"...
If we we're on the record where SampleID = 9... and on some event...
Dim PrevID as Long
Dim PrevDate as Date
Dim PrevHyd as Integer
1. Use DMax to find the SampleID that is one less than the current
SampleID
( varPrevID = 8)
2. Use Dlookup to find the SampleDate where SampleID = 8
(varPrevDate = 17/09/2004)
3. Use Dlookup to find the Hydrogen value of SampleID = 8
(varPrevHyd = 27)
RateOfChange = (Me.SampleDate - varPrevDate) / (Me.Hydrogen - PrevHyd)
There may be more elegant ways to accomplish this... but this should do
it.

Signature
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love, and you'll never work a day in your life."
> Al Campagna,
> To my understanding to calculate the rate of change between two points the
[quoted text clipped - 62 lines]
>> >
>> > Thanks
JonathanLewin - 18 Jul 2007 22:50 GMT
Al Campagna,
Thank you very much for your help with this, i have come up with an idea of
my own which is also not the most elegant way of carrying out the job but i
am confident it works and gives me the result i need. I will implement your
suggestion into my database and see which one is the most "elegant for my
database.
Thank you very much again for your assistance it is much appreciated.
Jonathan
> Jonathan,
> You really should have a autonumber key field for each record.
[quoted text clipped - 87 lines]
> >> >
> >> > Thanks
Al Campagna - 19 Jul 2007 05:32 GMT
Well, whatever works... works.
You could try both methods, and see if you get better from one or the other.
Good Luck

Signature
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love, and you'll never work a day in your life."
> Al Campagna,
>
[quoted text clipped - 110 lines]
>> >> >
>> >> > Thanks