Database Question

I'm wondering if anyone can help me with this...I have a recordet that is connected to a form via datacontrol...patients visit the unit 1 to 2 times per week and a record is entered for each visit..I want to get data from a particular record for that patient (i.e. visit #1) and compare it with a record that I am currently entering for that same patient. Am I making sense?? I need to use data from a previous record to do some math and compariosons from one visit to the next (on the same patient)...Help if you can..Thank You for any help...

All kinds of different things you could do.

Some of them even make sense. But first some questions:

By "first record" do you MEAN the first in the series, or do you
mean the first record prior to the potential current record?

either way, it's not a big deal

Thanks for responding...I mean the first record for that particular patient in the recordset (visit #1)...I use the patient MR# as the index key...I want to compare a measurement on the record I am currently entering, with that same measurement from the patients #1 visit to compare the difference...I hope that clears it up...I've made a rather large project and this little tidbit would help me tremendously (code example would be great)!!!