Some time ago, I did an aging accounts receivable report. While I don't have
the report any more (It was done in Access 2.0), I do remember that I used
the Partition function in a query to accomplish my goal. IIRC, there's 2 or
3 code examples in the helpfiles.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
"Stuart" <(E-Mail Removed)> wrote in message
news:1066DD3F-FCF4-4E3B-B2E1-(E-Mail Removed)...
> I was wondering if anyone out there has a recommendation for obtaining
source
> code for an Aged Trial Balance report. The logic seems quite complex, I'm
> wondering if someone out there has already done it and is willing to
share.
>
> Thanks, Stuart