Update Table?

[Guest]

I'm making a query that uses a table and a query table. I need the oput of
this query (which I want to be the records contained in the query that are
not in the table already) to be appended to the table.

I tried making an append query and doing the join property where you get
all the records from the query table and only the matching records from the
actual table, but it kept trying to append all the records again. I'm trying
to update the table. Thank you in advance for your help, and if you have any
suggestions on changing the format, they are also welcome.

 

[Al Campagna]

Joshua,
If tblOne had 1 thru 100 records and tblTwo had 1 thru 125...
Connect the two using Show All in tblTwo, and only those in tblOne that Match.
You should return 125 records, 25 of which have no tblOne value.
You should be able to use IsNull in tblOne as the criteria for the data from tblTwo to
Append.

 

[John Vinson]

I'm making a query that uses a table and a query table. I need the oput of
this query (which I want to be the records contained in the query that are
not in the table already) to be appended to the table.

I tried making an append query and doing the join property where you get
all the records from the query table and only the matching records from the
actual table, but it kept trying to append all the records again. I'm trying
to update the table. Thank you in advance for your help, and if you have any
suggestions on changing the format, they are also welcome.

Please post the SQL view of your query. It's awfully hard to guess
what you might be doing wrong when we can't see what you're doing!

John W. Vinson[MVP]

 

[Guest]

That worked perfectly. Thank you.

Joshua,
If tblOne had 1 thru 100 records and tblTwo had 1 thru 125...
Connect the two using Show All in tblTwo, and only those in tblOne that Match.
You should return 125 records, 25 of which have no tblOne value.
You should be able to use IsNull in tblOne as the criteria for the data from tblTwo to
Append.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions