cancel
Showing results for 
Search instead for 
Did you mean: 
snowol
Canine III

patient markers

Jump to solution

Hi there

I have been asked to provided data on wheelchair users seen in April, May and June 2021 respectively.

How can I run a report for a specific marker to show how many patients we have seen for each month?

Thanks

0 Kudos
Reply
1 Solution

Accepted Solutions
Alison_Daniels
CS Dental Employee
CS Dental Employee

Re: patient markers

Jump to solution

Good Afternoon 

To find the number of people with a certain marker that have attended within a particular time you need to create the following query.

  1. Open Query Wizard then click on New Query, select 'Start' then 'Next'.
  2. Scroll down and tick the row ‘that have the marker [Marker]
  3. Click ‘Specify Criteria’ and select the marker for a Wheelchair user in the Value Column then click ‘OK’
  4. Scroll up and tick the row ‘that have had an appointment’
  5. Click ‘Next’
  6. Select the option ‘between [No Date Specified] and [No Date Specified]’
  7. Click on ‘Specify Criteria’ and place a tick in the Ask Column and then click ‘OK’ in the window that opens.
  8. Do this for both rows and then click ‘OK’
  9. Then click ‘Finished’ and save the query.

When you run this query you will be asked to enter the start and end dates for the period of time you wish to search for, it will then return the number of patients with that marker that have had an appointment between those 2 dates.

I hope this will give you the information you are looking for.

Kind regards

Alison

View solution in original post

1 Reply
Alison_Daniels
CS Dental Employee
CS Dental Employee

Re: patient markers

Jump to solution

Good Afternoon 

To find the number of people with a certain marker that have attended within a particular time you need to create the following query.

  1. Open Query Wizard then click on New Query, select 'Start' then 'Next'.
  2. Scroll down and tick the row ‘that have the marker [Marker]
  3. Click ‘Specify Criteria’ and select the marker for a Wheelchair user in the Value Column then click ‘OK’
  4. Scroll up and tick the row ‘that have had an appointment’
  5. Click ‘Next’
  6. Select the option ‘between [No Date Specified] and [No Date Specified]’
  7. Click on ‘Specify Criteria’ and place a tick in the Ask Column and then click ‘OK’ in the window that opens.
  8. Do this for both rows and then click ‘OK’
  9. Then click ‘Finished’ and save the query.

When you run this query you will be asked to enter the start and end dates for the period of time you wish to search for, it will then return the number of patients with that marker that have had an appointment between those 2 dates.

I hope this will give you the information you are looking for.

Kind regards

Alison

View solution in original post