Count or Sum???

  • Thread starter Thread starter Graham Feeley
  • Start date Start date
G

Graham Feeley

I am trying this calc in a textbox on the footer of a flat table and this
wiull count the records where [r&q_rat] = 1....and it works fine
=Sum(IIf([r&q_rat]=1,1,0))
what I cant do is to count records where [r&q_rat]=1 and [pos]=1
can anyone please help me with this
regards
Graham
 
=Sum(IIf([r&q_rat]=1 and [pos]=1,1,0)

----- Graham Feeley wrote: ----

I am trying this calc in a textbox on the footer of a flat table and thi
wiull count the records where [r&q_rat] = 1....and it works fin
=Sum(IIf([r&q_rat]=1,1,0)
what I cant do is to count records where [r&q_rat]=1 and [pos]=
can anyone please help me with thi
regard
Graha
 
Thank you Jim, really appreciated that code, I really tried hard to get it
right but must have missed something as I was getting close.
regards
Grah
 

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

How do you sum on top of a group by 1
Help Needed: Create Sum in Report Footer based on aggregate expression 1
Help with Iif on Report 4
Dont count negatives...???/ 3
minimize repeating query criteria & generating monthly YTD totals 1
Pivot table calculated field Count(field) / sum(field) 0
DateDiff and Count/Sum 6
Fields not showing up in design view 1

Back
Top