Please help me whith DlookUp (1 Viewer)

I have table (TblInventory) for inventory with these fields (RepDate, ProdName, EndingInv, QtySold, QtyRcvd) Also I have query that will give me the begining inventory for each day which is the EndingInv of the previous date so I set up this DlookUp but it is coming back blank.

BegInven=DlookUp("[EndingInv]","TblInventory","RepDate=" & [RepDate]-1)

Please help me.

Thanks

Here's a good reference on the syntax required:

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

Personally I would not try to store the ending inventory.