Top Third Point Value

  • Thread starter Thread starter Charles Deng
  • Start date Start date
C

Charles Deng

Hi All:

Is there any way I can demonstrate the cut office point
for top 30% percent? For example, I have a variable
which has values like, 1,2,3,4,5,6,7,8,9,10. We know 8 is
the cut off point value for top 30%. Is there any way we
can demonstrate this value in our report? Any
suggestions, ideas, or hits will be very highly
appreciated.

Charles
 
Hi Duane:

I would like just show the cut off point in our report.
For the example I used in previous message, I would like
to show 8 in the column named as Top 30% Cutoff Value in
the report.


Charles
 
So your entire report would look like
========================
Top 30% Cutoff Value
8
========================
You should be able to create a query that selects the top 30% and then
create another query based on the top 30% that selects only the top one
record. Base your report on the last query.
 
Hi Duane:

What you suggested here is feasible. But our report also
needs to include percentage, average for each item. Can I
use multiple queries for ONE report? Thanks.

Charles
 
Charles said:
Is there any way I can demonstrate the cut office point
for top 30% percent? For example, I have a variable
which has values like, 1,2,3,4,5,6,7,8,9,10. We know 8 is
the cut off point value for top 30%. Is there any way we
can demonstrate this value in our report? Any
suggestions, ideas, or hits will be very highly
appreciated.
Click to expand...


How about using a text box in the report's Header or Footer
section with the expression:

=Min([the order by field])
 
Hi Marsh:

Thank you very much for your suggestion. But I am not very
clear about your expression. Could you a little bit of
further explanation?

Charles


-----Original Message-----
Charles said:
Is there any way I can demonstrate the cut office point
for top 30% percent? For example, I have a variable
which has values like, 1,2,3,4,5,6,7,8,9,10. We know 8 is
the cut off point value for top 30%. Is there any way we
can demonstrate this value in our report? Any
suggestions, ideas, or hits will be very highly
appreciated.
Click to expand...


How about using a text box in the report's Header or Footer
section with the expression:

=Min([the order by field])
Click to expand...
 
Presumably, you have a field that is used in the report's
record source query to select the Top 30%. That field must
be specified in the query's Order By clause. Use that field
in the Min function.
--
Marsh
MVP [MS Access]



Charles said:
Thank you very much for your suggestion. But I am not very
clear about your expression. Could you a little bit of
further explanation?

-----Original Message-----
Charles said:
Is there any way I can demonstrate the cut office point
for top 30% percent? For example, I have a variable
which has values like, 1,2,3,4,5,6,7,8,9,10. We know 8 is
the cut off point value for top 30%. Is there any way we
can demonstrate this value in our report? Any
suggestions, ideas, or hits will be very highly
appreciated.
Click to expand...


How about using a text box in the report's Header or Footer
section with the expression:

=Min([the order by field])
Click to expand...
Click to expand...
 
Back
Top