I am trying to use Access to carry out a clinical audit. I have very basic knowledge of access and can create basic DB consisting of simple tables and queries and forms etc. But I have hit a snag
1. Most important bit I need help with. Created a form with subforms for the questionnaires. Some of the questions appear on multiple forms. eg. on Form A looking at criteria for a head scan: Question: Is patient 65y or older?
Same question on Form B which looks at criteria for scan of patient's neck.
obviously if the answer on Form A is Yes, then the answer on Form B too Must be Yes as the patient's hasn't changed. There are few such instances of identical questions on different forms.
So I am trying to make the field on Form B automatically pick the response from Form A.
Pls see attached images.
Now I know you can do this pretty easily with VB. But I dont do VB so I need to be able to do that using Access expression builder ONLY.
2. To show me how to display a date as day of the week so that I can create a query to evaluate if a patient more or less likely to have a scan based on day of the week. Similarly I need to be able to display time patient seen as normal working hours (09:00-17:00 Mon-Fri) or not again to see if a patient is more likely to get a scan or not.
3. Calculating age between date of birth and date of attendance.
If required I can provide a copy of the database I have created.