In a query, I have the following fields:
I tried to sort the data by CustomerNamer whose OrderNo. has been sorted also. In the query, if I sort the Customer and OrderNo, but the OrderNo hasn't been sorted. Can anyone know the reason and how to fix it? Appreciated for any help!