Hi,

I have a table that is used for project progress. One of the fields is named "Completed". I would like to know if it's possible to auto fill the data in the "completed" field based on three other fields within the same table.

ex: If field 1 = Yes, and field 2 = Yes, and filed 3 = Yes, then field "completed" = Yes

I'm open for any ideas, I'm new to access and am not sure how to get this started.

Thanks

That is a common calculated field and simply a waste of disk space. Calculate it in a query whenever you need it.

Ok, I figured that much. I guess what I really need to know is the calculation for this. I have an idea, I just don't know the proper syntax.

Thanks

[Field1] AND [Field2] AND [Field3] As Completed
...assuming these three fields are Yes/No fields where Yes = True (-1) and No = False (0), the Boolean AND will give you the answer you need in the Completed field.