I created a summation query to count total number of checkmarks in a database and in the same query I asked to summarize the numbers in a field of the database.
This is the result of the query: 2 single columns with 760 for the total pages, and 4 for the total number of books.
I go to a form and insert a textbox. I insert an expression function: =[Query_statistiek]![Totaal_blz] to insert the above value "760" in the textbox. When I switch again to the form normal view, the field is filled with #name? instead of the retrieved value who is saved in the query (760).
Any idea what I did wrong? I checked several times the properties but do not know what I have forgotten. I'm a visual impaired person.