Access MS Access 2007 Aging Query


Joined
Dec 27, 2010
Messages
1
Reaction score
0
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Account Receivable Aging Report 1
Access Default Microsoft Access Order Entry database issue 0
Conditional Message Calculation 4
Embedded If Limitation 10
Macro Debug on Pivot Table 5
IF FORMAT 9
aging query and report 7
aging formulas 2

Top