help with calculating fields

[ddskorupski]

hello. first...this forum is excellent. This site has helped me tremendously. Here's what I need help with....

I have a database that is used to track:
1. an entire UAT life cycle
2. The documents that are submitted for the UAT testing

I have two tables: the first table trackes the specifics about the UAT cycle i.e. environment, application, pm, uat start date, uat end date, etch.

the second table tracks the documents and is linked by the app enviornment id to the first table.

What I need is a third table that contains calculated data from the first two tables. I need to be able to take the uat start date and calculate a document start date for two weeks earlier. Also, when a complete date is entered I want a field in the third table to automatically get check off as complete.

What is the best way to achieve this and how?

 

[DCrake]

Calculations are not usually stored in a table as they can be done in queries so you third table would be a query based on the other two tables.

Using the DateDiff() and IIF() functions would give you the answers you want.

David

 

[ddskorupski]

Thank you. I will give it a try.

 

[ddskorupski]

ok. this is not working. here is what I need. I want to create an append query that will append to table UAT Tracking using information from documents table

I want to create an if statement that says something like: if document date is not null, then true (with the true field being a checkbox in the uat tracking table.

how do I do this?