Count Not Null Fields

[bdtran]

Hello,



I’m new to Access and this is my first project as needed to create a new column “TotalCount” in the same table and insert the total count of all not null fields of the row record as shown in the pictures. Your advice is much appreciated.

[ranman256]

In the original query, convert all NULL to zero using NZ([field])
THEN produce this crosstab query.