Please post additional detail on what records you'd like
to select--the last 10% of records, the highest 10% of
sales, etc., and the basic purpose of your application.
I need to select 10% of all the records. This is basically
a status report on what records remain open. Every week I
need to select 10% of all open accounts to determine why
they remain open. I already have a query that will show
me only open accounts, so I would need 10% of those. An
average of 50 new accounts are opened per week so I
realize that each week my list of 10% will grow larger.
Well, a simple way is to use the query's Top Values
property. Set it to 10%, which will select the top 10%
values of the left furthermost field in the query grid.
If you want to select the largest balance accounts, sort
in descending order.
