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

http://www.dbforums.com/db_images_v3/images/buttons/edit.gif (http://www.dbforums.com/editpost.php?do=editpost&p=6401068)

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.