C
Catherine
using Access 2000 - I have a query that lists the number of accounts assigned
to each field agent. Accounts are assigned by zip codes (territories).
There are 5 basic territories that never change zip codes. There is a 6th
territory that I have no control over what zip codes may appear. I would
like to add a column in my query titled "other" to indicate any accounts that
would fall in that 6th territory. Right now my query "counts" the number of
accounts and lists the 5 basic territories in a summed fashion (which is
great) but I need all extra accounts to be summed into a territory called
"other" rather than listed individually.
I am very new to Access and my knowlege is limited. I appreciate any
solutions available. Thanks in advance.
to each field agent. Accounts are assigned by zip codes (territories).
There are 5 basic territories that never change zip codes. There is a 6th
territory that I have no control over what zip codes may appear. I would
like to add a column in my query titled "other" to indicate any accounts that
would fall in that 6th territory. Right now my query "counts" the number of
accounts and lists the 5 basic territories in a summed fashion (which is
great) but I need all extra accounts to be summed into a territory called
"other" rather than listed individually.
I am very new to Access and my knowlege is limited. I appreciate any
solutions available. Thanks in advance.