Hello all
Any help gratefully appreciated. I'm not an Access professional - just a mere physician trying to setup a regional level database to help care for people with a specific serious rare disorder.
I have developed a database with a single large table. These patients have numerous investigations - results dates and values. For example, the following NT-ProBNP blood test:
Field: Date_NT-ProBNP_1 Field: Result_NT-ProBNP_1
Field: Date_NT-ProBNP_2 Field: Result_NT-ProBNP_2
Field: Date_NT-ProBNP_3 Field: Result_NT-ProBNP_3
Field: Date_NT-ProBNP_4 Field: Result_NT-ProBNP_4
Field: Date_NT-ProBNP_5 Field: Result_NT-ProBNP_5
I want a form with a control that displays:
- the most recent test result, both date and result (numerical value)
- the test result (date and value) with highest and lowest result
I've managed to design the rest of this database OK just using macros as don't know anything about VBA.
Again any help would be very much appreciated - will make a difference to care of these patients.
Regards
Any help gratefully appreciated. I'm not an Access professional - just a mere physician trying to setup a regional level database to help care for people with a specific serious rare disorder.
I have developed a database with a single large table. These patients have numerous investigations - results dates and values. For example, the following NT-ProBNP blood test:
Field: Date_NT-ProBNP_1 Field: Result_NT-ProBNP_1
Field: Date_NT-ProBNP_2 Field: Result_NT-ProBNP_2
Field: Date_NT-ProBNP_3 Field: Result_NT-ProBNP_3
Field: Date_NT-ProBNP_4 Field: Result_NT-ProBNP_4
Field: Date_NT-ProBNP_5 Field: Result_NT-ProBNP_5
I want a form with a control that displays:
- the most recent test result, both date and result (numerical value)
- the test result (date and value) with highest and lowest result
I've managed to design the rest of this database OK just using macros as don't know anything about VBA.
Again any help would be very much appreciated - will make a difference to care of these patients.
Regards