I currently have 4 access Dbs, one for each region.
In the access Dbs is has all of the sku store combinatiaions for that region.
for example in the west it has 11 stores and each sku that each of those stores has (along with a lot of other date)
I currently hava Excell setup up to pull the data from those acess Dbs and it puts all of the data for all the stores into a nice table for me.
Is threre a way to just pull a single stores information?
For example i just want to pull all the Skus that store 123 has.
No before you say anything about me altering the access Dbs you should know that i "dont have the keys to that castle" its a big fight between me, my boss and some other poelpe as to weher or not i should be allowed to have that access but for the time being i do now.
Thanks for any help
In the access Dbs is has all of the sku store combinatiaions for that region.
for example in the west it has 11 stores and each sku that each of those stores has (along with a lot of other date)
I currently hava Excell setup up to pull the data from those acess Dbs and it puts all of the data for all the stores into a nice table for me.
Is threre a way to just pull a single stores information?
For example i just want to pull all the Skus that store 123 has.
No before you say anything about me altering the access Dbs you should know that i "dont have the keys to that castle" its a big fight between me, my boss and some other poelpe as to weher or not i should be allowed to have that access but for the time being i do now.
Thanks for any help