Incomplete Or Complete?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 6 tables, each table has a Yes/No field called [Incomplete] that
specifies if all questions (calculated on the Excel input template) have been
answered. I also have a table that acts as a high level control table - for
example the name of the project, the location, the Project Manager etc. It
also has a Yes/No [Incomplete] field. I would like to run a query that
checked the 6 tables and if all the [Incomplete] fields returned a value of
No - then the high level control table would automatically fill the
[Incomplete] field as no. I need to do this as when I run reports i need to
discount all data from incomplete projects.

I have no idea how to do this?!

I hope I have explained this ok - Any help would be great.

Cheers,

Phil
 
Depending on the data of the 6 tables, you may be able to link all the
tables, if not, then use a Union Query. I would try to return one record,
from the 6 table quagmire, that specifies whether all pass or there was a
failure. Use that as the basis for an Update query to the HLC table.

Just to be safe, post your table structures here, and let someone review the
concept before you do this.
 
Back
Top