I have one table that gets imported from a text file. This file has productID, type of sale, and count of sale. It's structured with 3 columns like this:
PSK DISP COUNT
xxxxx xx xx
Now this file does not contain any types of sale that have a count of zero. So the number of records does not match (text file with 654 and I'm supposed to have 1184)! Now I have another table (a template) that has the proper amount of records but no count and is set up like this:
PSK2 DISP2 COUNT2
xxxxx xx (blank)
I need the PSK's and the DISP's from both tables to match and populate the COUNT2 with COUNT's values where they do.
Please help me... Thanx
PSK DISP COUNT
xxxxx xx xx
Now this file does not contain any types of sale that have a count of zero. So the number of records does not match (text file with 654 and I'm supposed to have 1184)! Now I have another table (a template) that has the proper amount of records but no count and is set up like this:
PSK2 DISP2 COUNT2
xxxxx xx (blank)
I need the PSK's and the DISP's from both tables to match and populate the COUNT2 with COUNT's values where they do.
Please help me... Thanx
