Hi,

I'm accounting manager and MS-access developer. I need your suggest to building query about accounting receivable query, and then building a report (its record source is a/r aging query).

P.S.: As you know classical a/r aging query header are

* Company name
* period(1) 30-60
* period(2) 61-90
* period(3) 91-120
* period(4) >121



Already thanks,


Pegasus
[email protected]

Pega

Can you be more specific on what you want from your query? It sounds like you want a list of accounts based on how everdue they are. If so, what is the other data you want to show up in the query? Do you only want the company name? Can each company have multiple accounts?

Once you have the query, you can create the report using a wizard.

mmcdonal