So I have a simple query where I want to count the number of (for example) orders and take the average of the cost of the orders.
The query runs fine, but when I create a form based on the query, the count field is OK, but in the average field a #name? error is displayed.
I've verified that the field name in the form is not the same as the control source name. If I instead change the query to a make table query, and
then use the table as the control source of the from it displays OK. I've checked all the formatting, etc. and searched online but have come
up with no solution as yet. Thanks.
The query runs fine, but when I create a form based on the query, the count field is OK, but in the average field a #name? error is displayed.
I've verified that the field name in the form is not the same as the control source name. If I instead change the query to a make table query, and
then use the table as the control source of the from it displays OK. I've checked all the formatting, etc. and searched online but have come
up with no solution as yet. Thanks.