I have two tables: Case Information and Procedure Type. The Case Information table contains the Case # and the Procedure table contains the different types of procedures. One case # can have multiple procedures. So, I want to count the case # only once even if it has 3 procedures associated with it. I've read the other help but haven't seen one that has information coming from two tables.