Demographics by Zip Code

klinlv · Post by **klinlv** » Fri Jul 27, 2007 8:28 pm

How do I run a report to see the number of patients I have in each Zip Code in my database?

Post by **jordansparks** » Fri Jul 27, 2007 9:21 pm

SELECT Zip,COUNT(*)
FROM patient
WHERE PatStatus!=4
GROUP BY Zip

klinlv · Post by **klinlv** » Sat Jul 28, 2007 1:01 pm

Wow !!!!!

Thanks Jordan You are terrific..
I'm very happy that I dropped Softdent after 20 years for Open Dental. The incredible program and community that Open Dental users seem to have makes me know that it was absolutely the right choice for me.