Please, need help with A/R aging

  • Thread starter Thread starter Jim Evans
  • Start date Start date
J

Jim Evans

I hope that "queries" is the best place to ask this question. If not, I
apologize in advance.

I need to add an "Aging" of accounts receivable to a Statement report for a
customer.

The "Aging" must show total outstanding 30, 60, 90, etc. days. Can someone
point me in the right direction to understand how to do this?

Information for the balances for each customer is coming from a query
looking at Invoices (Invoice Number as Key) and Payments (Invoice Number as
Key).
 
Jim

We're not there, so we don't know anything about how your data is
structured, or how your query retrieves data.

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
 
This involves writing a query that uses calculated fields to sum the invoice
totals when the date of the query falls within each specified date window
for the calculated field (one calculated field for 0 - 30 days, one for 31 -
60 days, etc.).

Here is a Google search with a number of posts about this subject:
http://www.google.com/search?hl=en&q=access+query+aging+30+60+90

This is a common question, so I am reasonably confident that you'll find
what you seek in one or more of these previous posts. But, do post back with
additional questions about the query's structure or syntax.
 
I trust that you've been able to write the query that you sought. If not,
feel free to post here with additional questions.
Good luck!
 
Back
Top