Counting totals

[ptrifile]

I have a report where I am trying to get a count if 2 values match....I am using the following code but I am only returning a 1 on my report when I know that there is alot more...any help is appreciated.

=Abs(Sum([contacted]<0) And ([authorizationdate]=20050731))

 

[Remou]

Did you mean Less Than 0 (<0) or Greater Than 0 (>0)?

 

[ptrifile]

Hi Remou, I did mean (<0)LESS THAN as this field is a YES/NO field and I figured less than 0 would pick up all the ones checked or (-1). Any Ideas?

Paul

 

[Remou]

Sorry <slighly sheepish look>. The only other thing I can think of is the date, and I guess you have already looked at that.

 

[ptrifile]

Anyone else have any ideas?