DLookup on a DateTime field

[rjackson]

I have a simple table called Table1 with three fields - ID: AutoNumber, Field1: Text, and Field2: DateTime.
Query1 has two added fields - TextField and DTField.

TextField: DLookUp("[Field1]","Table1","[ID]=" & [ID]+1) This works just fine.

DTField: DLookUp("[Field2]","Table1","[ID]=" & [ID]+1) Gives an #Error



I have searched but I've only found #date# or #time# in the criteria parameter.
I want it to function like the TextField - return the value ( which is a Date/Time ) from Field2 of the next record to DTField.

[ranman256]

you really shouldnt use Dlookup in a query. The query is the Dlookup.
This will bog down the query significantly.

Is this an example, or what do you really want to do?