Count multiple colums from the table

[prabhus]

All,

I want to count data from my table ( Table ) and to display result like a dashboard (Desired result ). To count this what is the better way to do it?

do i need to write query for every column and then link to final column? i have totally 300 columns to count

I am attaching Table & desired result images;

 

[plog]

i have totally 300 columns to count

There's the problem. I don't think (as in I'm 98% certain) your database is properly structured. I think you need to work on structuring your table properly and then getting the data you want out will be easier.

Additionally, in Access there's a 255 limit on the number of columns a query can return, so this may be doomed any way.

 

[jdraw]

Please tell us in plain English what the table represents.

 

[prabhus]

There's the problem. I don't think (as in I'm 98% certain) your database is properly structured. I think you need to work on structuring your table properly and then getting the data you want out will be easier.

Additionally, in Access there's a 255 limit on the number of columns a query can return, so this may be doomed any way.

Hi,
I understand the limit and i used relationship to meet this requirement and i have this table runing already.
I dont understand your point that the table is not properly structured. This is a table just with the fields and the users check box inputs are stored here and i want to count the False values.

 

[Uncle Gizmo]

I don't understand your point that the table is not properly structured

This link may help you understand what Plog means:-

Excel in Access (Part 1)

 

[plog]

Read Gizmo's link, not only does it tell you about normalization in general, the examples are pretty specific to what you have.

In short, databases aren't just spreadsheets. You don't just add a new column for every new piece of data you want to capture. You have to have the right tables with the right fields in the right relationships to each other. That's what normalization is all about.

Again, read Gizmo's link.