change a value in one field based on the dates in all records for the same patient

jom1918

Registered User.
Local time
Tomorrow, 04:09
Joined
Apr 26, 2011
Messages
30
I have database of referrals for patients receiving psychological services from various providers. Three main tables are referrals, patients and sessions linked by the referral number (rid). Some psychologists delay sending in data so as new data is provided, the session number needs to change based on the date that the psychologist delivers the session not when we get the information. When we get the data, it might be the first record for that referral so sess_number = 1, but then they send in another form and it is for a session delivered on an earlier date, so both the existing record and the previous session records session numbers need to change.

On a form called "referrals_frm" I have a subform called "sess_subfrm" which contains the relevant controls - "sess_date" and "sess_number".

When I create a new session record for the referral and enter the sess_date, I want all the sess_numbers for all sessions belonging to this referral to re-number from oldest sess_date to newest sess_date.

Is there a way to do this?

Please help. This is a bit beyond my existing understanding of vb and MS access.
 
I will assume that you have patient, under patient you have referral then under referral you have session. The nature of your question is that you are happy with the patient referral link however you are not happy with how the sessions are listed. You would prefer to rank the sessions by date. Once the sessions are ranked by date, you would like to update the session numbers so that they follow the date ranking order. That's what I got from your question if it's not quite on the button then please provide additional information...
 

Users who are viewing this thread

Back
Top Bottom