New patient report

[abelaguilar]

Hello all:

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

Thanks

[Jorgebon]

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

[abelaguilar]

Thanks i'll try it.