SQL or Query to identify unused fields in a table?

  • Thread starter Thread starter Chrisso
  • Start date Start date
C

Chrisso

Hi there,

I have just been given a poorly designed database with over 100,000
records in one table. This table has a lot of fields and it seems that
apart from the first seven the rest do not hold too much data.

I would like to create a query that tells me how many records actually
have data in each field. I am having troouble doing this.

My pseudo-code is:
for each field in the table
count the number of Null fields
report

Any ideas wil be gratefully accepted.

Chrisso
 
Chrisso said:
Hi there,

I have just been given a poorly designed database with over 100,000
records in one table. This table has a lot of fields and it seems that
apart from the first seven the rest do not hold too much data.

I would like to create a query that tells me how many records actually
have data in each field. I am having troouble doing this.

My pseudo-code is:
for each field in the table
count the number of Null fields
report

Any ideas wil be gratefully accepted.

Chrisso
Click to expand...

No code needed. In a new Totals query...

DataCount1: Sum(Abs(IsNull(Field1)))
DataCount2: Sum(Abs(IsNull(Field2)))
etc..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated field in a table 6
Parsing a table 1
How to build a "reach around" query? 5
Append only Null records in table 2
Appending records to new table using field names as values 2
Query with multiple tables won't let me change data. 2
Using the "Forms Object" on more than field in a query table 2
Turning a 3 column flat file into a "3D" Table 2

Back
Top