Hi XPS35,
Hi All,
XPS35 has provided the solution to my previous query and really works. Single average value per Cust_
I revised the query due to additional requirements by filtering the class"M" from ">#01/09/2022# And <#01/9/2023#"
But the form display several values of Cust_A, Cust_B instead of single average value, and the Cust_C does not display.
May I request you to please check. Attached is the Database, you can apply the the correct formula in the attached file.
Thanks you.
Hi All,
XPS35 has provided the solution to my previous query and really works. Single average value per Cust_
I revised the query due to additional requirements by filtering the class"M" from ">#01/09/2022# And <#01/9/2023#"
But the form display several values of Cust_A, Cust_B instead of single average value, and the Cust_C does not display.
May I request you to please check. Attached is the Database, you can apply the the correct formula in the attached file.
Thanks you.