Problem: Trying to count the SUPPLIER_ID field in the CLIENT_MASTER_FILE table using an expression in an unbound control based on the Supplier selected from a combo on a form.<BR><BR>I'm trying it two ...

Learn how to use the dcount() function to return an estimate of the number of distinct values of an expression within a group. Calculates an estimate of the number of distinct values that are taken by ...