I would like to run a report to show during and after the pandemic that we had to catch up with denplan patients and the spike in activity that had to be caught up with for denplan
Please can you give me more information on what you would like to run your report on, I would be happy to help.
The only idea I have based on your current information is to see how many exam treatment items on Denplan patients were done during different months. For example 100 in march 2020, 10 in April 2020, 300 in December 2020. This would should the effect of the pandemic. You could then compare the data from the normal year 2019, see how 2020 went and how 2021 is going.
This can be done using management reports. You will need to know the treatment code for each, which can be found inside the charting screen. For example Clinical Examination - 101.
Hope that helps
You can create a query but would have to run it for each individual appointment type. If this is ok, follow these steps:
You can now search for Appt types between two dates.