Please, need help with A/R aging

[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).

 

[Jeff Boyce]

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

 

[Ken Snell \(MVP\)]

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.

 

[Jim Evans]

Ken,

Thank you. Your insight has helped much.

Jim Evans
KAS Broadband Administration

 

[Ken Snell \(MVP\)]

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!