Instead of doing the count of DMAs, use countd (count distinct). If you are using Excel or Access, you'll have to take an extract to get this function. This function counts all the unique marks.
Hope this helps!
Thanks Tracy. I was completely puzzled as to why I couldn't use CountD() as I was using an Access Source. Thank you again!