DLookuo Function with Date criteria

[mnazera]

Can anyone help me, what DLookup function retrieve Date criteria ?

Example :

DLookup ("[Fielname]","TableName", "[Date]= "&[Date]-1)

I would like calculate value in same field in table between one record with previous record


thank

 

[pbaldy]

Here's a good reference:

http://www.mvps.org/access/general/gen0018.htm