Number of Data Count in Each column of a table

[Blessy clara]

Hi All,



I have an Ms Access table - with 100 Columns
Each Column has data
I want to know how many data are there in each column for the overall table

Example Table Name: NSW
Column 1 - 100 (count of data)
Column 2 - 5000 (count of data)
Like wise for all the 100 columns in table

Please advice , on how to create the query

Thank you

[Bulzie]

SELECT Count(NSW.Column1) AS CountOfColumn1, Count(NSW.Column2) AS CountOfColumn2 FROM NSW;

Or in query designer, add table, add all fields, click on the Totals/GroupBy button and select Count in the Total row.