I hope this message finds you well today.
I am looking for some help on running a report on patients that have attended for emergency appts between 22/03/2019 - 22/03/2020. Could you help me running 2 reports for a) emergency appts b) non emergency (standard) appts
Thank you for your post.
To create a query to find patients who have had an emergency appointment between two dates:
Note: If you have multiple emergency appointments then you will need to create this query for each appointment type that you use.
To create a query to find patients who have had a non-emergency appointment between two dates:
Note: You can only select one appointment type in the in this query so if you use multiple emergency appointments then this query will not exclude all of them.
Good morning, please see below how to create 2 queries to find the information you require.
Create a query to find the Total number of completed appointments between 2 dates:
Create a query to find the Total number of completed emergency appointments between 2 dates:
Thanks for the messages. And could you tell me how to run a report with a specific treatment code (for emergencies) as the report does not seem to be accurate if it's run with the appt type.
To change the query to how completed treatment items please see below.
Create a query to find the Total number of completed emergency treatments between 2 dates: