Creating a query to automatically update a field in a table

[yeeehooo]

I have built a form that tracks our paperwork as it is processed. I need to include time frames from the date the paperwork is received to the date it is complete.

I have four fields in the form that are used by my employees. The fields are as follows:
Today's Date
Date Received
Date Completed
Time Frame to Complete

I need to have the "Time Frame to Complete" box automatically update when the date completed changes. If there is not an entry in the "Date completed' box, then I would like the result to be "Today's Date" - "Date Received"

I have completed this in an excel spreadsheet using nested IF functions, but cannot seem to accomplish this in access.

Please help!!!

[missinglinq]

I'm afraid you'll have to be a little clearer, yeeehooo!

I need to have the "Time Frame to Complete" box automatically update when the date completed changes.

"Time Frame to Complete" updated to what?

If there is not an entry in the "Date completed' box, then I would like the result to be "Today's Date" - "Date Received"

The result in "Time Frame to Complete" or the result in "Date Completed?"

And do you want "Today's Date" to be the actual date you're looking at the record, i.e. 7/29/2007 today and 7/30/2007 tomorrow?

Let us know and we'll figure it out for you.

Welcome to TheScripts!

Linq ;0)>

[yeeehooo]

Thanks for looking at this, I hope I am able to explain clearly what I'm trying to do.

I have an access database that displays the customer's name, address, phone number, etc. The information is entered by multiple employees through the form I have created. There are a few boxes I constructed that you can input dates for tracking the speed and process of paperwork. The boxes are labled as follows:

Date Docs Received Application (Short Date Format)
Date Docs Completed Application (Short Date Format)
Time Frame (Completed Date - Received Date)
Today's Date (Date the user is looking at the record)

The dates in the Date Docs Received Application and Date Docs Completed Application are manually inputted.

The Time Frame box will not be manually adjusted. I am trying to get it to show one of two options.
Show: "Date Docs Completed Application" - "Date Docs Received Application"
IF Date Docs Completed Application is blank
Then "Today's Date" - "Date Docs Received Application"

If the "Date Docs Completed Application" is changed to a different date, I would like the "Time Frame" box to automatically update with the new result. I hope this is possible, as I want the results to automatically be displayed into the Time Frame box.


Thanks for looking at this once again, your help is very much appreciated!!