Greenhorn needs some major help!!!

[TEllison]

So Ive eliminated all of the unnecessary queries, and added the completion percentage to each query. Now I have 1 query for all audits.

The problem Im having now is how do I get the [Completion Percent] from each query to either populate back in the "Index Table" or put into a separate new table? Every way I have tried it will not let me for some reason or another.

 

[plog]

You don't store calculated values, instead when you need them you calculate them. That means [Completion Percent] doesn't exist in a table, it exists in a query.

Can you post your revised database along with what you want the final dataset to look like?