B
Bonnie
Let's see if I can explain my question as easy as possible...
I am trying to create Macro using SQL Statements. This is what I want to
happen:
I currently have three columns in a table: Store #, Region, and Location
EX. of data:
Store # Region Location
0001 0123 ABC
0002 0123 DEF
0003 4567 GHI
0005 0123 JKL
0006 0123 MNO
0007 4567 PQR
The relevant information I need is under the Store # and Region, I don't
need the Location information.
However, I would like to use the Location column to indicate something
different.
If Sore # equals 0001 and Region equals 0123, I want the field under
Location to change to 'Atlanta 1,' not ABC.
If Store # equals 0002 and Region equals 0123, I want the field under
location to change to 'Atlanta 1,' not DEF
If Store # equals 0005 and Region equals 0123, I want the field under
location to change to 'Atlanta B,' not JKL.
Basically, I am looking for an SQL Statement that will allow me to match up
two fields in a record and then change the third field. I understand I will
have to write an SQL statement for each combination I want to have changed.
It will save me time in the long run.
This is what I would want the table to look like after I run the Macro:
Store # Region Location
0001 0123 Atlanta 1
0002 0123 Atlanta 1
0003 4567 Columbus 3
0005 0123 Atlanta 2
0006 0123 Atlanta 1
0007 4567 Columbus 1
Thanks in advance if you can help!!!
I am trying to create Macro using SQL Statements. This is what I want to
happen:
I currently have three columns in a table: Store #, Region, and Location
EX. of data:
Store # Region Location
0001 0123 ABC
0002 0123 DEF
0003 4567 GHI
0005 0123 JKL
0006 0123 MNO
0007 4567 PQR
The relevant information I need is under the Store # and Region, I don't
need the Location information.
However, I would like to use the Location column to indicate something
different.
If Sore # equals 0001 and Region equals 0123, I want the field under
Location to change to 'Atlanta 1,' not ABC.
If Store # equals 0002 and Region equals 0123, I want the field under
location to change to 'Atlanta 1,' not DEF
If Store # equals 0005 and Region equals 0123, I want the field under
location to change to 'Atlanta B,' not JKL.
Basically, I am looking for an SQL Statement that will allow me to match up
two fields in a record and then change the third field. I understand I will
have to write an SQL statement for each combination I want to have changed.
It will save me time in the long run.
This is what I would want the table to look like after I run the Macro:
Store # Region Location
0001 0123 Atlanta 1
0002 0123 Atlanta 1
0003 4567 Columbus 3
0005 0123 Atlanta 2
0006 0123 Atlanta 1
0007 4567 Columbus 1
Thanks in advance if you can help!!!