> 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]" wrote:
>
>> 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.
>> --
>> Arvin Meyer, MCP, MVP
>>
http://www.datastrat.com>>
http://www.mvps.org/access>>
http://www.accessmvp.com>>
>>
>> "Antavas" <Antavas[ at ]discussions.microsoft.com> wrote in message
>> news:849CD4C7-5D12-4061-8AA0-ECB26218ACC1[ at ]microsoft.com...
>> >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........................
>>
>>
>>