Re: Appending a record
- From: "Roger Carlson" <NO-Roger.J.Carlson-SPAM@xxxxxxxxx>
- Date: Wed, 8 Feb 2006 09:21:14 -0500
OK. I don't know what you're doing wrong but try this for your update
query:
UPDATE Table1 INNER JOIN Table2 ON Table1.BatchID = Table2.BatchID SET
Table1.[Solv GAL] = [table2].[Solv GAL], Table1.[PT LB] = [table2].[PT LB],
Table1.[Acid LB] = [table2].[Acid LB];
In this example, I'm using "Table1" and "Table2", but you should use your
actual table names.
Give this a try and see what happens.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
<LCallesen@xxxxxxxxx> wrote in message
news:1139345544.923390.320830@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Roger-
Thank you so much for all of your help so far. I did exactly what you
suggested. Everything seemed to work (aka, I did not receive any
errors), but the query did not appear to update the fields. I brought
the new text file into a temporary table as you suggested, which worked
fine.
This is where my knowledge really gets fuzzy. I can't be 100% sure
that I joined the tables correctly, or that my update query is working
as it should.
Here is a little more background on my project:
I am creating a database to keep track of information from a chemical
process (ie. temperatures, weights, etc...) Some of the information
can be automatically read in, while others have to be manually entered.
Some of the automatic information is available as soon as the batch
starts, and is imported to create the new record. Operators can then
enter most of the other manual data while the process is running via a
form. However, toward the end of the process, there is more
information that automatically comes in and has to be added to the
database and associated with that particular batch. This is the second
.txt file. The common field is named "Batch ID" and the fields that I
am updating are "Solv GAL", "PT LB" and "Acid LB". These names are the
same in both tables.
If you need more information, please let me know. Thanks (again) in
advance...
Lindsey
.
- Follow-Ups:
- Re: Appending a record
- From: LCallesen
- Re: Appending a record
- References:
- Appending a record
- From: LCallesen
- Re: Appending a record
- From: Roger Carlson
- Re: Appending a record
- From: LCallesen
- Appending a record
- Prev by Date: Re: Switching ODBC Oracle databases
- Next by Date: Re: how do i import a text file with line wraps into a table
- Previous by thread: Re: Appending a record
- Next by thread: Re: Appending a record
- Index(es):
Relevant Pages
|
