Helping a BIG file prob...

[Szuja]

If anyone can answer this, I have a colossal situation.

In Access, I have two tables. One of the fields has similar dat
(having identical line items), the rest do not. I'd like to create on
table from these two tables, using one as a base but adding a coupl
extra fields from the other.

Now, the fields with duplicate data I want to overwrite/merge.
If Table 1/Field 1 (item number for inventory in both tables) contain
data also in Table 2/Field 1, use Table 1 data *but* I need to ad
particular data from Table 2 (quantity and pricing) that correspond
with the item number field from Table 2. (Did I make sense?)

Is there any way to do this? My boss says if I can't get it done I'l
have to do it by hand, and that's 25000 lines of text...

Thanks in advance for any help! :

 

[Roxie Aho]

1. Is Item Number a primary key in each table (indexed, no
duplicates)?
2. Does Table 1 have quantity, price fields?
Roxie Aho
roxiea(delete)@usinternet.com

-----Original Message-----
If anyone can answer this, I have a colossal situation.

In Access, I have two tables. One of the fields has similar data
(having identical line items), the rest do not. I'd like to create one
table from these two tables, using one as a base but adding a couple
extra fields from the other.

Now, the fields with duplicate data I want to overwrite/merge.
If Table 1/Field 1 (item number for inventory in both tables) contains
data also in Table 2/Field 1, use Table 1 data *but* I need to add
particular data from Table 2 (quantity and pricing) that corresponds
with the item number field from Table 2. (Did I make sense?)

Is there any way to do this? My boss says if I can't get it done I'll
have to do it by hand, and that's 25000 lines of text...

Thanks in advance for any help!



------------------------------------------------

 

[Szuja]

I wanted to use Item number as a primary key (realizing that this woul
simplify my life! ) but it keeps telling me there are Null value
(which I can't see why - there are no blanks, every value is unique
etc).

I may have to do it by hand, and experience the pain of 25000 entrie
But I just can't see a way to merging the docs

 

[Szuja]

I added the QTY and Price fields in Table 1. My main hang-up is that
can't make Item Number a primary key - if I could, then I could just d
an append query, right

 

[Szuja]

Oh, I got it!

Thanks for your help - I was able to just copy and paste them together
- it's messy, not exactly what I was after, but it'll do nicely. Thank
you very much!!