Thanks for the responses. I should have been more specific when I asked my original question. The table uses 2 fields as the key. So, Piti, how does that affect the count expression? Would it be--count(field1, field2) or count(field1 AND field2)? Or did I unleash a beast?
Does anybody know how it is possible to get duplicate keys in a table? Better yet, does anybody know how to track them down? I have two records with the same keys, and I can't think of any SELECT statement that would find them. Any ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.