I have been trying to create an aging report or query an have been frustratingly unsuccessful. My fields are [Invoice ID], [Invoice Date], and [Open Amount]. My Aging Buckets need to be Current (or 1-30 days), 31 - 45 days, 46 - 60 days, 61 - 75 days, 76 - 90 days, 91 - 105 days, 105 - 120 days, and 120+ days.
I have faily good knowledge of creating queries, but very limited subqueries. Any assistance would be very much appreciated.
I have faily good knowledge of creating queries, but very limited subqueries. Any assistance would be very much appreciated.