Hello,
I'm hoping someone might know how I can word what I need in a way access can perform it.
I have a table that holds hundreds of case numbers. I'm currently working on a query that tells me how many cases we have. The tricky part is that I want it to tell me the number of cases and not just add up the case numbers. I also want it to subtract any duplicate numbers. Case numbers are often repeated and I want it to only count a number that is duplicated once. I'm not sure how to do this.
Does anyone have any ideas?
Thanks,
Megan