Report filter

[Antavas]

I have an excel report we work on a monthly basis that gets imported into
Access. However, we do not work on the entire report just a portion. Is there
a way to have access filter down to the precentage we do work on?

So for instance:
50% of the AB items
25% of the CD items
etc........................

 

[Arvin Meyer [MVP]]

You would have to know which records you wanted to select. If you add an
autonumber column, you can select the first or last half, or every other
record (or every 4th record), or possibly a random sample of half of them.
Or you can select records on the basis of having or not having certain
criteria, but then you couldn't guarantee that there would be a specific
percentage. It might be a good idea to then append those records to a new
table and delete the original import.

You would need several queries to do this, and possibly several functions to
run in those queries. You need to be more specific, before we can help
further.

 

[Antavas]

The report we get contains up to 8 different types of transactions. So let's
say A through H to describe them.

We review 100% of types A & B
25% of type C and
50% of types D through H

Right now we manually go through the excel report and delete out what we
won't review. I was hoping that there was a way to make access do this for us
since the original report and the report we actually review both get uploaded
into seperate tables.

 

[Arvin Meyer [MVP]]

So 25% is one out of every 4. If you have a criteria, you can use the Top
predicate in a query:

SELECT TOP 25 PERCENT *
FROM MyTable
ORDER BY SomeData;

Or you can use the MOD function to select every 4th record:

SELECT *
FROM MyTable
WHERE ((([ID] Mod 4)=1));
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com