Open a blank Excel spreadsheet.
Switch to
...
the Data
...
tab and click
...
the Existing Connections
...
button.
...
In the window that opens, choose the query you’d like to run (e.g., Immunizations
...
or Birth Control) from under
...
the Connection files on this computer
...
section and click
...
the Open button.
...
When you see this window, click
...
the OK button.
Give it time to load and then it will show you the data in a blue table on the spreadsheet. The default is shows you all of the data from January 1, 2014 to the present day.
Filter the Data
Click the down arrow in
...
the Day
...
column to open the following menu.
...
Uncheck (Select All)
...
and then check only the years that you want to see. You can also click the + icons to open and filter even further by months or days.
Once you have the date range you want to see, click
...
the OK
...
button and the table will show only your chosen days/months/years.
Next, click the down arrow in
...
the Comments column.
Uncheck (Select All)
...
and then check only the items that you want to see and then click
...
the OK button.
Check
...
the Total Row
...
option in
...
the Table Tools Design
...
tab to get the total number of rows auto-calculated at the bottom of the table.
Note You must click on a cell in the blue table in order to see the Table Tools Design tab
When you are done with the query, close the Excel spreadsheet
...
and do not save it; you need to start from the beginning each time so that it pulls the most recent data.
Repeat the above process to see the other query (e.g. Immunizations
...
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| hidden | true |
|---|
...
or Birth Control).