Good morning All !
I am trying to setup a MS Access database (MS Access 2019) to facilitate lesson plans creation for my school.
So far, everything is working fine (Tables, Form, Query), but when I generate the report, based on the query, I have three textbox (Teaching_Materials, Homework_type, and Past_Paper_type) which are displaying the wrong column/field....
Instead of displaying, for example the "Short_Name_ field", the "ID" field is displayed in the report...When in the Query, it shows the text (multiple values), as expected....
Any hints?
I am trying to setup a MS Access database (MS Access 2019) to facilitate lesson plans creation for my school.
So far, everything is working fine (Tables, Form, Query), but when I generate the report, based on the query, I have three textbox (Teaching_Materials, Homework_type, and Past_Paper_type) which are displaying the wrong column/field....
Instead of displaying, for example the "Short_Name_ field", the "ID" field is displayed in the report...When in the Query, it shows the text (multiple values), as expected....
Any hints?