Hello All,
I am using MS Access....
As I run the data, I have each client's appointments listed (1st, 2nd, etc.)
I need a total count of appointments for each client (Number of Appts)...
I know how to create a count in Excel, but not sure how to attempt this in Access...
How do I add a count in Access to give me total number of appointments? (similar to what I have below)
<tbody>
</tbody><colgroup><col><col span="3"><col><col></colgroup>
I am using MS Access....
As I run the data, I have each client's appointments listed (1st, 2nd, etc.)
I need a total count of appointments for each client (Number of Appts)...
I know how to create a count in Excel, but not sure how to attempt this in Access...
How do I add a count in Access to give me total number of appointments? (similar to what I have below)
CLIENT | 1ST APPT | 2ND APPT | 3RD APPT | 4TH APPT | NUMBER OF APPTS |
DOE, JOHN | 8/1/2017 | 2/1/2018 | 2 | ||
DOE, JANE | 9/2/2017 | 10/1/2017 | 3/2/2017 | 3 | |
DOE, JAKE | 10/5/2017 | 12/5/2017 | 2/5/2018 | 3/3/2018 | 4 |
DOE, JUNE | 11/15/2017 | 6/18/2018 | 2 | ||
DOE, JOE | 6/22/2018 | 1 |
<tbody>
</tbody><colgroup><col><col span="3"><col><col></colgroup>