I have two tables like this

 

Account ID	DC Date
123456	5/6/2011
567890	6/26/2011

 

Transaction	Account ID	Post Date
300	123456	5/6/2011
301	123456	5/7/2011
302	123456	5/8/2011
303	567890	6/26/2011
304	567890	6/26/2011
305	567890	6/26/2011
306	567890	7/22/2011

 

I need Count of the accounts whose Postdate > DC Date in other words for Account ID 123456 I need a count when postdate > dc date so the count will be 2 the final result should look like this

123456	2
567890	1

 

I grouped it by account id and used the following formula

if({DCdate},{accountid})< ({postdate},{accountid}) )
then 1
else 0

 

but it is giving me syntax error,donno how to proceed further.If you help me out that will be great.

 

Thanks in advance