how to set up an Accounts Payable Aging 1

[Guest_imported]

I need to "age the Accounts Payable in our system. I have an invoice date, but I want to show it as 60 days, 90 days past due in seperate colums on a report. I don't know how to get Access to do this. Do I set up these parameters in the criteria field in a query or do I build an expression.

Thanks

 

[JerryDennison]

Build an expression. You can do it a couple of ways. If all you want to do is show that it's 60, 90, or more than 90 days past due you can use nested IIF() statements:

PastDue: IIF(DateDiff(&quot;d&quot;,Format([DueDate], &quot;Short Date&quot,Format(Now(), &quot;Short Date&quot) >= 90, &quot;90 Days&quot;,IIF(DateDiff(&quot;d&quot;,Format([DueDate], &quot;Short Date&quot, Format(Now(), &quot;Short Date&quot) < 90,IIF(DateDiff(&quot;d&quot;,Format([DueDate], &quot;Short Date&quot,Format(Now(), &quot;Short Date&quot) >= 60, &quot;60 Days&quot;, &quot;&quot

I haven't tested it, but hopefully you get the picture. Of course, if you'd create a function it'd be a lot easier to use anywhere you needed it.