Passing field value to a case to a query

M

MyMel

I have a table with 30 fields, I need to query each field for 3 different
responses and place the results into a table.

1. Check for non-unique.
2. Check for NULL count
3. Perform unique value count

I was told that this task could be performed using a case statements. By
assigning each field a case number.

Case 1
ACCT_ID
Case 2
ALT_ACCT
Case 3
TYPE_CD
Case 4
CUST_NAME
Case 5
CUST_TYPE_CD

I though about running the first query through the fields output to a table
then follow through with the next query. My problem is I cannot figure out
how to do this or if this is the best way. Help, please!!
 

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

Drop down list control value in vba 2
Autonumber field in Excel that behaves the same as Access 0
Append Crosstab Query to Existing Table 0
Possible to Combine reports to's to a single box? 0
WORD VBA Search and switch to advanced ... 1
Setting column width in a table with a macro is not working 0
How to Create an S-Curve from Custom Field? 0
How to display zero value in blank fields of Cross Tab query 0

Top