View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default queries with multiple criteria

hi
how are you doing this query? ADO? MS Query? Other? what are you calling a
"typical query". information llike that would be very helpful.
i think the easiest thing to do is go back to access and write the query
there. it would be a lot easier. then all you have to do is download the
access query results via MS query. i have done this many time and for many
years and it's a lot easier to download access querys than to try and write
the query in excel.
and in that way, excel becomes just a query viewer.....a "front end" in
which you can manipulate the data further should you wish.

post back with more info on the query method.

Regards
FSt1

"Sandre" wrote:

hello :)

I have an access database that maintains master information on all CSRs in
my department, their production, and their errors. I am trying to bring the
information about specific errors into excel by category. The problem is
that each of the error categories is listed by client. So, for example, I
have errors on client A's letters, errors on Client B's letters, errors on
client A's envelopes, errors on client b's envelopes.

What I am trying to do is total all of the letter errors, and all of the
envelope errors by CSR, regardless of which company they were charged to.
There are 20 clients overall that have this data stored, so a typical query
with "or" functioning won't work, there are too many fields.

Short of doing an individual query per client per error, is there an easier
way to get this information tallied?

Thank you!