Conditional Update of Columns

[menendeza]

Greetings to all. I have a database where staff keeps tracks of uploaded documents to a government portal. The original design wasn't properly thought out so I'm trying to simplify. They have several forms called for example, Form A, Form B, Form C and they created one column for each form. If the form was uploaded they created a Choice Column where the only two options are "Blank" (because they haven't uploaded the form) and "Uploaded" when the form has been uploaded to the portal. I created a "Yes/No" Column to check "Yes" when the document is uploaded and "No" as the default value. I would like to update the columns where any entry marked as "Uploaded" in any of the forms columns is marked as "Yes" in the associated Yes/No column I created.

What would be the best way to do this? Update Query? Macros? Any suggestion is appreciated.
Thanks.

[Welshgasman]

I would normalise the table to start with.
Otherwise you need an OR for each of the columns.

[orange]

I agree with gasman in that you need to start with a normalized structure that meets and supports your requirement. Perhaps you could tell us more about the process(es) involved.

This is my interpretation of your setup.
You/your organization is required to submit some document(s) to government by a certain date.
You or someone in your organization is tasked with completing the document/form.
You or someone in your organization is tasked with verifying the information on the document/form.
You or someone in your organization is tasked with sending/delivering the completed document to the government portal.
You or someone in your organization or as a byproduct of any automation is tasked to keep a record(s) of what has been delivered and when.

Also, consider

Typically government processes can require "audits"/formal review from time to time for compliance to some law/mandate.
You may need to retain records and submitted info --more than just a Yes/No a document was sent.
You may require/develop standard operating procedures for the completion, submission and retention of documents generally.
With some analysis of current processes and requirements, you may find that the processing of the document may just be a byproduct of performing/automating some of the main processes of your business.

It may be helpful to describe exactly what is missing or incorrect in the current database, and keep a note as to how it could be corrected.

You may find some of the articles in my Database Planning and Design link helpful.

Good luck.

[Micron]

Agree with the others, but in the interest of solving this problem, you will have to run an Update query on the table and set [Uploaded] field to "Yes" WHERE myYN_Field = True.
FYI, tables don't have columns - those are fields.

[NoellaG]

Columns and rows are correct SQL terms, just as attributes and tuples, or fields and records ;-)