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
 
Back
Top