New patient report

For users or potential users.
Post Reply
abelaguilar
Posts: 87
Joined: Tue Jun 19, 2007 3:26 pm
Location: Manchester, GA
Contact:
Contact abelaguilar

New patient report

Post by abelaguilar » Mon Dec 10, 2007 8:45 pm

Hello all:

Wondering how can I generate a report listing new patients to the office.

Thanks
Abel Aguilar, DMD
http://www.DrAguilar.com
Top
User avatar
Jorgebon
Posts: 502
Joined: Mon Jun 18, 2007 2:25 pm
Location: Mayaguez, PR
Contact:
Contact Jorgebon

Post by Jorgebon » Tue Dec 11, 2007 1:22 pm

This query is from the query examples page. You can modify it to get a report with the specific fields you would like and the dates you want:

SELECT * FROM PATIENT
WHERE DateFirstVisit >= '2005-10-01'
AND DateFirstVisit < '2005-11-01'


Jorge Bonilla, DMD
Top
abelaguilar
Posts: 87
Joined: Tue Jun 19, 2007 3:26 pm
Location: Manchester, GA
Contact:
Contact abelaguilar

Post by abelaguilar » Tue Dec 11, 2007 3:12 pm

Thanks i'll try it.
Abel Aguilar, DMD
http://www.DrAguilar.com
Top
Post Reply

Return to “Main Forum”