Dear Greg,
>From the details furnished by you, I presume that you are trying
append the data from one table to another which has duplicate data.
There is a option in access querry. First create a querry opening the
table to which you want to append data.(eg Table A) Go to the design
of the querry, on the querry drop down button select the append
querry. The system will ask you to chose the another table
(eg.Table.B).Then your querry will provide you with a option Append to
on the design. Chose the corresponding matching fields from the tables
and run the querry. The table A will be appended with the data of
Table B.
With regards
Krishnadas Rai
On 5/3/05, Greg Saucier <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Can someone help me figure out if its possible to
> merge two tables together into one while maintaining
> existing data?
>
> For example, Table A has fields X & Y and Table B
> has fields Y & Z. I want to make a new table (or query) with
> X, Y & Z and have all the records match (there are
> duplicates) when I am done.
>
> Thanks
> Greg
>
>
> Yahoo! Groups Links
>
>
>
>
>
--
T.Krishnadas Rai
"RAI's" 101, 3rd C Cross
1st G Main, East of NGEF,
Kasturinagar
Bangalore-560043
Ph: 25425635 (R)
25366116-2284 (O)
9845061899 (Mob)
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
