relationships and wrong results

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
 
G

Guest

Can you post your SQL? It would also be helpful if you would list the column
names for the two tables

It appears that the only difference between is what appears to be some sort
of record number (maybe an ID field) in Table 2, and the path to the image,
also in table2. Why do you even need table 1?

Dale
 
Top