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
 

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
Differences between 2000 and 2003 1
query for a report 2
query prompts 2
Nz - need code - 2
Nz or Iif 8
Show a zero 5
2 crosstabs 1

Back
Top