Page 1 of 1
Demographics by Zip Code
Posted: Fri Jul 27, 2007 8:28 pm
by klinlv
How do I run a report to see the number of patients I have in each Zip Code in my database?
Posted: Fri Jul 27, 2007 9:21 pm
by jordansparks
SELECT Zip,COUNT(*)
FROM patient
WHERE PatStatus!=4
GROUP BY Zip
Posted: Sat Jul 28, 2007 1:01 pm
by klinlv
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.