Sum(IIF statement

J

Jay

I have a large table that I want to query 2 things from. Please be patient
because I am pretty new at this.

I need to count the number of times that something appears in some fields in
the table. Below is what I have tried (keep in mind there are many more
fields to count)...
test: [Exp1]=Sum(IIf([Account number] Is Not Null,1,0)+(IIf([Address] Is Not
Null,1,0))

I would like my output to look like:

KEY TEST
1 2
2 0
3 5
etc...

And then I want to look in each of those same fields and if there is data
concatenate it into one field on the query output and look something like
this:

KEY TEST TEST1
1 2 address, account number
2 0
3 5 address, account number, other field, other field2, etc...

Thanks in advance for any help you can provide
 

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

Using IIF to count the is not null records in a table 8
union query problem 16
Between date with greater than or eaqual to 4
A followup to my TALLY NULL question 2
AVG in query with condition 1
Read Only Query, need a little help 1
Compare Fields with < But Get #Error 4
Running sum expression 2

Top