Firstly I would like to know if the following is possible.
The data is stored in two tables in MS Access.
First table is called ‘OPBASE_tbl’ which contains a list of patients that have an attendance in the hospital. The date of the attendance is identified by the ‘Date Of Session’ field. Every patient has a unique ID ‘UNITNO’,
The second table is called ‘OUTPATIENTS_tbl’, which also contains UNITNO (unique identifier) and the appointment date.
What I want is if a record in ‘OPBASE_tbl’ (G110007/2)
If a patient (G110007/2) has 3 records on ‘OPBASE_tbl’ - 09/04/2008, 30/04/2008, 11/06/2008
UNITNO Date Of Session EP_TYPE Matched
G110007/2 09/04/2008 N
G110007/2 30/04/2008 F
G110007/2 11/06/2008 F
Then I want to place a tick on the record for 09/04/2008. the methodology I am using is, if the appointment occurs between the two date of session on the OPBASE_tbl, place a tick on the first date, (between the two dates)
If the Appointment Date was the 01/05/2008, then a tick would be placed on the second field (30/04/2008)
I’m just thinking how this would be done in Access? I usually use queries but can’t think how this can be done. Do I need to write a module of some sort?