Search results

Is [Product Name] I have Add the [Product Code] and Now I have trying by IIF AND But It is showing the current date balance only. =IIf(([Product Code]=[Product Code]) And ([Date]<Now()),[Balance FB Quantity],0) Appreciate your cooperation.:)

But Dear It is showing same result #Name?.

As per ur advice I have used the code : but result return #Name? I am using product name from drop down menu.

Dear, As per ur advice I have used the code : =DLookUp("[Balance FB Quantity]","Production Finished Bricks","[Date]=#" & Format(Forms![Production Finished Bricks]![Date]-1,"mm/dd/yyyy") & "# And [Product Name] = '" & [Product Name]=[Forms]![Production Finished Bricks]![Product Name] & "'")...

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...