Replies

Rather than appending a new record, consider using an Update query to update the address fields in the target table.

To see all the operators, lookup the word Operators in the Help index.
You do not need the = in your expression. Just type the phrase you want to display in the parameter window within square brackets.

[Type the operation number]

Place it in the criteria cell for the field on which you are performing the search.

Sorry, I did not understand that one of the date/time stamps you needed to reference was in a previous record. The only way I know how to reference a previous record is by using VB. You would create a recordset, find the record, hold the date/time value, then move to the previous record to obtain the previous record’s date/time stamp. That would give you the references for the DateDiff calculation. If you like, I can post an example of VB code that moves between records to gather values or someone else may know a non-VB method to accomplish this.

Look at the DateDiff Function in the Help index, which returns the number of time intervals between two specified dates. Use Now() as the third argument to calculate the number of time intervals from the system date/time.