G
Guest
Hi there,
I'm trying to update a column in my data which will add a name based on what
weight bands it falls into.
I have one table which contains three columns: weight start and a weight end
value (both as long integers) and a name for each weight band (eg Name of
Supplier: Swisspost, WeightStart = 0, WeightEnd = 100, then the next row
would be Name of Supplier: La Poste, WeightStart = 101, WeightEnd = 500 and
so on) and one table which contains a weight of item and Supplier.
I want the Supplier field to be updated with the correct supplier name based
on the weight band it falls into.
How do I go about doing this?
Thank you ind advance for your help.
K
I'm trying to update a column in my data which will add a name based on what
weight bands it falls into.
I have one table which contains three columns: weight start and a weight end
value (both as long integers) and a name for each weight band (eg Name of
Supplier: Swisspost, WeightStart = 0, WeightEnd = 100, then the next row
would be Name of Supplier: La Poste, WeightStart = 101, WeightEnd = 500 and
so on) and one table which contains a weight of item and Supplier.
I want the Supplier field to be updated with the correct supplier name based
on the weight band it falls into.
How do I go about doing this?
Thank you ind advance for your help.
K