Aging report

  • Thread starter Thread starter cdabilis@aetna
  • Start date Start date
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.
 
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;
 
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.
Click to expand...
Click to expand...
 
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top