Posted on 2014-02-26
Table is tblOrders
Field Name is CustomerNumber
I want to display the number of times a CUSTOMER has placed an order.
So, if I am looking at a form that displays a single order for CUSTOMER 888 - I want the form to display that this CUSTOMER has 999 Orders already.
Each time an order is displayed on the screen , then there should also be a display of the total number of orders placed by that customer.
What's the DCOUNT format??