need help

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

hi all,

let say i have 99 rows in table.now i wanna extract field
[age] from its number 80%of total rows which is 0.8*99=79.2
(after taking out decimal number will be row#72).

but in this case let say row#70 until row#75 have same age
thus it only pick the last which is row#75.

And how can make all queries compact if i also want to
calcutate for its 75%,70%,65% and 60%.

please help,

rgds,
bob
 
correction:
it should be row#79 instead of row#72.
thus lets change the range between row#76 until row#80
 
On Wed, 28 Jul 2004 20:24:21 -0700, "bob"

Bob, most people who post here need help. Those of us who volunteer
expect that; it is helpful if you use a more informative subject line
(such as "Getting top 80% of records").
hi all,

let say i have 99 rows in table.now i wanna extract field
[age] from its number 80%of total rows which is 0.8*99=79.2
(after taking out decimal number will be row#72).

but in this case let say row#70 until row#75 have same age
thus it only pick the last which is row#75.

And how can make all queries compact if i also want to
calcutate for its 75%,70%,65% and 60%.
Click to expand...

You can create a Query based on your table; sort ascending by Age. Now
select View... Properties (or press F4, or right mouseclick in the
grey background of the query, and select Properties); set the Top
Values property of the query to 80 and choose "percent".
 
Back
Top