If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Time calculation
Hi gang,
I've already been he http://www.mvps.org/access/datetime/date0004.htm I have 2 time fields, "Time In" and "Time Out". I have a third field, a number field, that is to receive a difference of the 2. Like I said, I tried the expression from the link above and got this error: "The database engine does not recognize either the field "Time In" in a validation expression, or the default value in the table "Task" " I'm assuming the expression from the link is to go into the Default Value section of the intemded field. Can anyone please explain to me,like a 4-year old, what I did incorrectly?? Thanks very much, Paul |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Elapsed Time Calculation? | Ken | General Discussion | 1 | September 15th, 2004 08:51 PM |
time zone & apt times auto changing | Mary | Calendar | 6 | May 25th, 2004 05:44 AM |
time calculation | David McRitchie | Setting up and Configuration | 2 | March 28th, 2004 09:14 PM |