>I am trying to calculate the cost of aged receivables in different time >ranges. I want the total costs of receivables in the last 30 days, 31-60 days, >61-90 days and 91 and over depending on the date specified which will be most >of the time today's date. I don't know how to create a SQL statement that >would do this as a new year creates problems in determing the number of days >ago it happened. I hope that makes sense. I'm having troubles getting my head >around it and explaining it.

>TIA,
>Tyler

Select Sum(iif(Date() - DateReceivable < 30, CostReceivable, 0000000.00)) as nCost30, Sum(iif(Between(Date() - DateReceivable, 31, 60), CostReceivable, 0000000.00)) as nCost3160, Sum(iif(Between(Date() - DateReceivable, 61, 90), CostReceivable, 0000000.00)) as nCost6190, Sum(iif(Date() - DateReceivable > 91, CostReceivable, 0000000.00)) as nCost91 ...

I think will help you

Philippe