Aging report

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

 

[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;

 

[cdabilis@aetna]

How would you do the same in Excel?

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

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.

 

[KARL DEWEY]

Post your question to an Excel newsgroup.

--
KARL DEWEY
Build a little - Test a little

How would you do the same in Excel?

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

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.