Hi everyone,
I just joined the forum and look forward to some good feedback from everyone (I have read this forum a lot for ideas/help before and am an intermediate Access/SQL user).
Here's some basic information and I'll put an example below. I work for a cell phone carrier and working on some analysis to see how many customers have upgraded/downgraded their device. So I need to see if the customer has received multiple shipments, if the first device shipped is a "Flip Phone" and the second one shipped is a "Smartphone", I need to update another column to say "Upgrade". If it is a "flip" to "flip" with "exchange" as the order type, this is an "exchange" and "smartphone" to "flip" is a "downgrade".
So in a nutshell, I need to compare to see if the customer numbers are the same, if they are, check the order type for "warranty exchange", check first shipment device and compare to second shipment device, then update another field.
As a bonus, I have a table that has all the possible combinations of upgrades/downgrades/exchanges that I would like to utilize, but this is an "extra bonus" if anyone would know how to utilize this. Please let me know if more details, examples, etc. are needed and thanks for all the help in advance.
CustNo---PhoneType---OrderType---ToBeUpdatedField
001---Flip---Direct---Direct Order
001---Smart---Direct---Upgrade
123---Smart---Direct---Direct Order
123---Flip---Direct---Downgrade
456---Flip---Regular---Direct Order
456---Flip---Exchange---Exchange
456---Flip---Regular---Direct Order
789---Smart---Regular---Direct Order
789---Smart---Exchange---Exchange
789---Smart---Regular---Direct Order