This is probably really simple but I'm unable to figure this out! I need to create a formula that will give me an unduplicated total of client records in my database. If I put in a date range and come up with a list of clients that received services during that date range, I want it to then give me the total number of clients served within that date range unduplicated. Some clients may have been seen multiple times during the time period but I only want the individual client counted once.
Any help would be greatly appreciated!