Update Query

[Jamie Dickerson]

I have a table which lists WO#'s (primary Key), the related item# and a
yes/no field reflecting wether the WO is open or closed.

I have a second table which records reject rates. This table also includes
the WO#.

I would like to update the second table to reflect wether the WO# is open or
closed based on the first table.

Is this possible and if so how?

I appreciate any help offered.

 

[KARL DEWEY]

Why not just join the two tables in your queries so the open/closed status
will be shown without having to update?

Have you considered using a CloseDate field instead of Yes/No for the
indication?

 

[Jamie Dickerson]

Thanks for the help Karl. Joining them worked perfectly. I don't know why I
didn't think of that earlier.