Microsoft Access - Count Multiple Cells (Fields)

[Manny74]

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)

[TABLE="width: 661"]
<tbody>[TR]
[TD]CLIENT[/TD]
[TD]1ST APPT[/TD]
[TD]2ND APPT[/TD]
[TD]3RD APPT[/TD]
[TD]4TH APPT[/TD]
[TD]NUMBER OF APPTS[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD]8/1/2017[/TD]
[TD]2/1/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]DOE, JANE[/TD]
[TD]9/2/2017[/TD]
[TD]10/1/2017[/TD]
[TD]3/2/2017[/TD]
[TD] [/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]DOE, JAKE[/TD]
[TD]10/5/2017[/TD]
[TD]12/5/2017[/TD]
[TD]2/5/2018[/TD]
[TD]3/3/2018[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]DOE, JUNE[/TD]
[TD]11/15/2017[/TD]
[TD]6/18/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]DOE, JOE[/TD]
[TD]6/22/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[/TR]
</tbody><colgroup><col><col span="3"><col><col></colgroup>[/TABLE]

 

[sheetspread]

Is sgn(Nz([APPT 1],0)) etc any better? If not, are the fields static or part of a crosstab query?