Need queries for patients by age and gender

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
wjstarck
Posts: 936
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:
Contact wjstarck

Need queries for patients by age and gender

Post by wjstarck » Mon Oct 12, 2009 11:42 am

Hello-

I need queries for:

# of new patients summarized by age for a given date range
# patients, again summarized by age, for a given date range who have completed at least some treatment planned, and the production totals

the same 2 above, but summarized by gender...
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA
Top
Post Reply

Return to “Advanced Topics”