Hello.
I’ve built a database. I have two main data entry tables; one called “personal details”, one called “testing”.
In the personal details table, I have fields such as; Surname, Name, DOB, Phone number etc…..there is also a staff ID number field (this is unquie to that staff member).
In the testing details table, I have fields such as “Blood pressure cholesterol level, weight, BMI etc”. Again, there is also a staff ID field.
I created a relationship between the two “Staff ID” fields in each table.
I have created a form (personal details) with a subform where the testing data is. This seems to work correctly.
I’ve then produced a report via the report wizard. In the report I want staff no, name, test date and all the test measures (BP, cholesterol, weight etc). However, after selecting, producing and saving the report, if I attempt to open the report again, I get an error message that reads
“Type mismatch in expression”.
Any ideas what I’ve done wrong??
Many thanks
