Database Question

[albaken]

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

[DerFarm]

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

[albaken]

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)!!!