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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
