PC Review


Reply
Thread Tools Rate Thread

Using two tables to append to another table - Help!

 
 
Antell
Guest
Posts: n/a
 
      1st Jun 2004
I'm using two unrelated tables to append another table.
Each time I run the query, it adds the correct
information, but does it twice.

Table1: Employee ID, and other employee info
Table 2: Survey code, and other survey into
to append to
Table 3:

Table 1 and 2 do not have a "join".
 
Reply With Quote
 
 
 
 
Dwayne Shrum
Guest
Posts: n/a
 
      1st Jun 2004
It sounds like you really want to do this in two steps
which means table 1 will do the append (meaning to add new
records to table 3), then do a seperate update query
(meaning to change the fields that were not previously set
with the new information from table 2).

For example: Insert new record for employee with all the
table 3 defined fields - using data from table 1.

Then, modify that same record (only fields that pertain to
table 2) with table 2 data.

So the two steps are completely different query modes -
insert vs update.


>-----Original Message-----
>I'm using two unrelated tables to append another table.
>Each time I run the query, it adds the correct
>information, but does it twice.
>
>Table1: Employee ID, and other employee info
>Table 2: Survey code, and other survey into
>to append to
>Table 3:
>
>Table 1 and 2 do not have a "join".
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Append rows from a table into another table using a list box tommu Microsoft Access Getting Started 3 26th Feb 2008 08:10 PM
INSERT SQL to append recs frm another Table, NULL DATE append 30/1 accesshar Microsoft Access VBA Modules 2 14th Jan 2008 03:00 PM
Using append/update queries to transfer record data from one Table to another Table DiDi Microsoft Access Queries 1 4th Jan 2007 05:12 PM
re:Help to append flat file table to two tables Vika Microsoft Access Queries 1 21st Sep 2005 10:55 PM
re:Help to append flat file table to two tables Vika Microsoft Access Queries 1 20th Sep 2005 08:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:48 AM.