Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple function queries in same cell | Excel Worksheet Functions | |||
Multiple queries under same connection | Excel Discussion (Misc queries) | |||
Refreashing queries in multiple spreasheets | Excel Discussion (Misc queries) | |||
Importing multiple XML queries into Excel | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions |