As always make a backup of your tables or database, if nothing else it will
give you peace of mind in knowing that nothing you do can cause any real
damage.
Then, all you need to do is run an update query. Make a new query, pull in
tables A and B. Link fields A.1 to B.1, go to query type and select update.
Drag B.7 to your output fields section, and enter your desired value in the
"update to" section.
Run the query and you're done.
Chris said:
Yes. I only need it changed if (a)(1) = (b)(1) though, first time really
getting into access so I'm still wet under the ears with it. It seems so
simple but I can't seem to find the information anywhere.
Lance said:
You want to permanently change the value of
.[7] ? If so, you would need
to run an update query, link [A].[1] to .[1] and update .[7]
Chris said:
I have two tables (a) and (b) for simplicity sake. Can you link them
conditionally as such.
If field 1 table a = field 1 table b then table b field 7 = yes?
