cancel
Showing results for 
Search instead for 
Did you mean: 
joannalevie
Canine II

Report for patients last attended 11 years ago

Jump to solution

On R4 + How do I get a list of patients that have not attended since e.g. 2007 

Labels (2)
0 Kudos
Reply
1 Solution

Accepted Solutions
sleightpa
CS Dental Employee
CS Dental Employee

Re: Report for patients last attended 11 years ago

Jump to solution

Hello Joanne.

you can create a query for patients whose last completed appointment was before your chose date

Select search for a patient - select query wizard then new query - select start - select next - select specify attributes - Scroll down the Fields section on the left side, and select - " Last completed appointment " and select add.- in the field " Equal to " earlier than " in the next field labelled

 " Value " select the date in your case - 2007. in the section marked - 1 Absolute,  select OK,  and finish and save with the name you wish to use.

Then back in the select patient screen, select your query and then select run .

Hope this helps

View solution in original post

3 Replies
sleightpa
CS Dental Employee
CS Dental Employee

Re: Report for patients last attended 11 years ago

Jump to solution

Hello Joanne.

you can create a query for patients whose last completed appointment was before your chose date

Select search for a patient - select query wizard then new query - select start - select next - select specify attributes - Scroll down the Fields section on the left side, and select - " Last completed appointment " and select add.- in the field " Equal to " earlier than " in the next field labelled

 " Value " select the date in your case - 2007. in the section marked - 1 Absolute,  select OK,  and finish and save with the name you wish to use.

Then back in the select patient screen, select your query and then select run .

Hope this helps

View solution in original post

Hopedental123
Canine II

Re: Report for patients last attended 11 years ago

Jump to solution

Hi, 

I have followed these steps to make the query but it is only bringing up one patient and she is current..

There are many patients that haven't attended for over 11 years. 

Thanks. 

0 Kudos
Reply
stephen_skelton
Moderator
Moderator

Re: Report for patients last attended 11 years ago

Jump to solution

Hi,

Please see the following Knowledge Base article that has a handout that shows you how to create query to display all patients who have not been seen for 11 years.  The query does include steps to only include patients who are over the age of 25 but of you do not want to limit your results by age then skip steps 5 through to 10

https://community.carestreamdental.com/t5/R4-Documentation/How-to-Generate-a-List-of-Patients-over-2...

Regards

Stephen

0 Kudos
Reply