I have a database of customers, inside that database is a portal to a database of invoices.
I want to find out how many of a certain item number they have purcashed.
I tried using the exact function in a calculation field but it returns only a 0 or a 1. how else can I get it to count how many of a certain item they have purchased?
I want to find out how many of a certain item number they have purcashed.
I tried using the exact function in a calculation field but it returns only a 0 or a 1. how else can I get it to count how many of a certain item they have purchased?