G
Guest
I have 2 excel sheets that I import into Access. They look like this
Table 1
92 DVD's & Video's Dvd- Zipper Pulls 6-00104 49.99
92 DVD's & Video's Dvd- Making Turk's Head Bracelet 6-00103 49.99
92 DVD's & Video's Dvd - Making A Decorative Keyfob 6-00102 49.99
92 DVD's & Video's Dvd - Decor. Knotting & Braiding 6-00101 69.99
92 DVD's & Video's Free Forming & Lasting 0027-01 39.99
Table 2
3171 92 DVD's & Video's DVD- Zipper Pulls 6-00104 /6/11-27048.jpg 49.99
3172 92 DVD's & Video's DVD - Decor. Knotting &
Braiding 6-00101 /6/6-00102.jpg 69.99
3173 92 DVD's & Video's DVD - Making A Decorative
KeyFob 6-00102 /6/6-00103.jpg 49.99
3174 92 DVD's & Video's DVD- Making Turk's Head
Bracelet 6-00103 /6/6-00104.jpg 49.99
Result
92 DVD's & Video's Dvd- Zipper Pulls -655822 /6/11-27048.jpg 49.99
92 DVD's & Video's Dvd- Making Turk's Head
Bracelet -656188 /6/6-00104.jpg 49.99
92 DVD's & Video's Dvd - Making A Decorative
Keyfob -656553 /6/6-00103.jpg 49.99
92 DVD's & Video's Dvd - Decor. Knotting &
Braiding -656918 /6/6-00102.jpg 69.99
I create a relationship between the 2 tables on the SKU field in Both
tables. for instance 6-00104 is the same in both tables and distinguishes
them as the same. When I run a report that joins these 2 together the sku
field changes to a regative number. This field is set to text on both tables.
Any idea why its doing this... And its not doing it to all the records. It
seems to be random to me
Table 1
92 DVD's & Video's Dvd- Zipper Pulls 6-00104 49.99
92 DVD's & Video's Dvd- Making Turk's Head Bracelet 6-00103 49.99
92 DVD's & Video's Dvd - Making A Decorative Keyfob 6-00102 49.99
92 DVD's & Video's Dvd - Decor. Knotting & Braiding 6-00101 69.99
92 DVD's & Video's Free Forming & Lasting 0027-01 39.99
Table 2
3171 92 DVD's & Video's DVD- Zipper Pulls 6-00104 /6/11-27048.jpg 49.99
3172 92 DVD's & Video's DVD - Decor. Knotting &
Braiding 6-00101 /6/6-00102.jpg 69.99
3173 92 DVD's & Video's DVD - Making A Decorative
KeyFob 6-00102 /6/6-00103.jpg 49.99
3174 92 DVD's & Video's DVD- Making Turk's Head
Bracelet 6-00103 /6/6-00104.jpg 49.99
Result
92 DVD's & Video's Dvd- Zipper Pulls -655822 /6/11-27048.jpg 49.99
92 DVD's & Video's Dvd- Making Turk's Head
Bracelet -656188 /6/6-00104.jpg 49.99
92 DVD's & Video's Dvd - Making A Decorative
Keyfob -656553 /6/6-00103.jpg 49.99
92 DVD's & Video's Dvd - Decor. Knotting &
Braiding -656918 /6/6-00102.jpg 69.99
I create a relationship between the 2 tables on the SKU field in Both
tables. for instance 6-00104 is the same in both tables and distinguishes
them as the same. When I run a report that joins these 2 together the sku
field changes to a regative number. This field is set to text on both tables.
Any idea why its doing this... And its not doing it to all the records. It
seems to be random to me