Dear Friends,
I have joined the forum new and need help.
=DLookUp("[Balance FB Quantity]","Production Finished Bricks","[Date]=Forms![Production Finished Bricks]![Date]-1" & [Product Name]=[Forms]![Production Finished Bricks]![Product Name]=[Product Name])
There is 7 product in a day I am...