Aging buckets Access 2003

[bootster]

I consider myself a power user but not a programmer. I looked thru Reports and saw no requests like the one I am going to post. I want to create a query that lets me sum payments in buckets <30 30-59 60-89 ... 150-179 180and>



I can find the days with the DateDiff and force the dollar amounts in new fields in a table with a series of update queries for each range and then report from the table. I am hoping to find a way to just query that payment date and subtotal that amount in a reporting field from a single query.

Any help is appreciated. I will probably just blank stare at any VBA answers - but post them as they may help others with a similar need.

Thanks,
Steve

[pbaldy]

I do it in SQL Server, so it's a little different, but the equivalent would be something along the lines of summing on this in a totals query:

IIf(TotalDays < 30, AmountField, 0)