Query

  • Thread starter Thread starter Pass-the-reality
  • Start date Start date
P

Pass-the-reality

On a query, I used the following - One Call: IIf([SumOfCount]=1,1,0)
which places a 1 in the One Call column if SumOfCount equals 1

How would I write add a 1 in the Multiple Calls column if the SumOfCount
calls are 2,3,4 or 5.

I do not want to use IIf([SumOfCount]>1,1,0) as I will also have a column
marked 6 or More Calls which will shown anything >6
 
Pass-the-reality said:
On a query, I used the following - One Call: IIf([SumOfCount]=1,1,0)
which places a 1 in the One Call column if SumOfCount equals 1

How would I write add a 1 in the Multiple Calls column if the SumOfCount
calls are 2,3,4 or 5.

I do not want to use IIf([SumOfCount]>1,1,0) as I will also have a column
marked 6 or More Calls which will shown anything >6
Click to expand...


A little thought should suggest this:

IIf([SumOfCount]>1 And [SumOfCount]<6,1 0)
 

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

Query 1
query for a report 2
Nz or Iif 8
Show a zero 5
2 crosstabs 1
UNION QUERY 1
Is there no "AND" function in Access like in Excel? 2
Fields not showing up in design view 1

Back
Top