Aging report

C

cdabilis@aetna

New to access and doing queries, but I need to know how to set up a query
that will automatically run an aging report of on hand items that are not
completed. For example, open work items are assigned a received date and I
need to know what parameters to enter to have it capture open items 1-30
days, 31-60 days, etc.
 
K

KARL DEWEY

SELECT *, IIF([Received] > Date()-30, "1 - 30", IIF(Date()-[Received] Between
31 And 60, "31 - 60", IIF(Date()-[Received] Between 61 And 90, "61 - 90",
"Greater than 90"))) AS Aging
FROM YourTable;
 
C

cdabilis@aetna

How would you do the same in Excel?

KARL DEWEY said:
SELECT *, IIF([Received] > Date()-30, "1 - 30", IIF(Date()-[Received] Between
31 And 60, "31 - 60", IIF(Date()-[Received] Between 61 And 90, "61 - 90",
"Greater than 90"))) AS Aging
FROM YourTable;
--
KARL DEWEY
Build a little - Test a little


cdabilis@aetna said:
New to access and doing queries, but I need to know how to set up a query
that will automatically run an aging report of on hand items that are not
completed. For example, open work items are assigned a received date and I
need to know what parameters to enter to have it capture open items 1-30
days, 31-60 days, etc.
 
K

KARL DEWEY

Post your question to an Excel newsgroup.

--
KARL DEWEY
Build a little - Test a little


cdabilis@aetna said:
How would you do the same in Excel?

KARL DEWEY said:
SELECT *, IIF([Received] > Date()-30, "1 - 30", IIF(Date()-[Received] Between
31 And 60, "31 - 60", IIF(Date()-[Received] Between 61 And 90, "61 - 90",
"Greater than 90"))) AS Aging
FROM YourTable;
--
KARL DEWEY
Build a little - Test a little


cdabilis@aetna said:
New to access and doing queries, but I need to know how to set up a query
that will automatically run an aging report of on hand items that are not
completed. For example, open work items are assigned a received date and I
need to know what parameters to enter to have it capture open items 1-30
days, 31-60 days, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top