I currenty have table with the following information.
SalesOffice Client ProductHeld Volumes
Office1 Client1 Product1 $10000
Office1 Client1 Product2 $20000
Office2 Client1 Procuct1 $5000
Office1 Client1 Product3 $50000
Office3 Client1 Product2 $60000
I need to be able to identify the sales office with the
highest frequency for a given client (ie. Office1 in this
example). With this information I need to update the
salesoffice field to reflect the sales office with the
highest frequency. For example, in the above office 1
would be identified as the sales office with the greatest
frequency. I need to then change the record for office 2
and office 3 to office1.
Can anyone help me with this problem. Thanks in advance.
.
SalesOffice Client ProductHeld Volumes
Office1 Client1 Product1 $10000
Office1 Client1 Product2 $20000
Office2 Client1 Procuct1 $5000
Office1 Client1 Product3 $50000
Office3 Client1 Product2 $60000
I need to be able to identify the sales office with the
highest frequency for a given client (ie. Office1 in this
example). With this information I need to update the
salesoffice field to reflect the sales office with the
highest frequency. For example, in the above office 1
would be identified as the sales office with the greatest
frequency. I need to then change the record for office 2
and office 3 to office1.
Can anyone help me with this problem. Thanks in advance.
.
