I have a table that I want to show 3 fields. The first field is grouped by the salesman name. This is no problem. The second is a sum of all open order totals which is not problem. The third is a sum of all open sales that is more than 90 days past the order date. I tried writing something like sum(Iif(datediff(dayofyear,orderdate,today())>90,i tem.price,0)). Of course this doesn't work. Any ideas on how to do it. I cannot filter in the query because I need all entries not just over 90 days. I need to do it in the field of the table.

I figured out a way to do it. I created a case in the sql query that checked for a datediff of greater than 90, if so, it returned the price, if not it returned a 0. I then added a sum of the field for each group in the table of the report. Worked like a charm.