Counting # of Rows by Age

  • Thread starter Thread starter SkyMgr
  • Start date Start date
S

SkyMgr

Chris,
Thanks for the reply. However, I tried doing what you
suggested in a new DB and I keep getting an error because
the system doesn't like "Count"(Transform Count). Is there
another solution or expression that I could use?
Additional information:
In my original DB I used a query to obtain the # of days
overdue "DaysDue: Date()-T_Proposal![Due Date]" and got
(28) ranges from -33 to 233 days. On the report, I created
four boxes at the footer and added a build
expression "=Count ([period]<30)" and so on for each box.
The result was 21, which was incorrect. I tried adding an
* before [Period]and the count was 28, which is all of the
rows from the query. My object is to create an aging
report summary for past dues (Less than 30, 30, 60, 90).
Please help.
Thanks,
SkyMgr
 
SkyMgr,

What is the error message is it issuing? (I can't interpret "doesn't
like".)

What, exactly, were the steps that led up to the error?

Also, remember, my examples were meant as an enabler to *try* and give you
ideas. Because of the inexact nature of my understanding of your particular
problem, you will no doubt have to discard bits and pieces of it. Based on
how badly I understood, you might have to discard the whole thing. No
matter how hard those here try and help, sometimes what we suggest may do no
good at all.


See more below:


Sincerely,

Chris O.


SkyMgr said:
Chris,
Thanks for the reply. However, I tried doing what you
suggested in a new DB and I keep getting an error because
the system doesn't like "Count"(Transform Count). Is there
another solution or expression that I could use?
Additional information:
In my original DB I used a query to obtain the # of days
overdue "DaysDue: Date()-T_Proposal![Due Date]" and got
(28) ranges from -33 to 233 days. On the report, I created
four boxes at the footer and added a build
expression "=Count ([period]<30)" and so on for each box.
The result was 21, which was incorrect. I tried adding an
* before [Period]and the count was 28, which is all of the
rows from the query. My object is to create an aging
report summary for past dues (Less than 30, 30, 60, 90).
Click to expand...


Perhaps a Sub-Report based on the Crosstab Query to be placed at the
bottom of the main Report?
 
Back
Top