This is a really basic question, but I can't seem to make it work.
I have a simple table with 3 fields.
Each field is defined as a date/time datatype.
StartTime and EndTime are manually entered.
I'm trying to use the DateDiff() function in an update query to populate the ElapsedTime field with the number of seconds elapsed between StartTime and EndTime.
I put the ElapsedTime field on the query grid, convert the query to an update query and on the "Update To" row of the ElipsedTime column, I've entered: DateDiff("s", [StartTime], [EndTime])
When I run the query, I don't get any errors, but the ElapsedTime field in the table does not update.
Can you tell me what I am doing wrong?