If, Then

[Chris]

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?

 

[Lance]

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]

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.

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]

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?

 

[Lance]

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.

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.

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]

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?