Ben_Entrew
Registered User.
- Local time
- Today, 11:11
- Joined
- Dec 3, 2013
- Messages
- 177
Hi all,
can somebody please help me?
Something is wrong with this dlookup in :
I debugged a and t these variables are correct.
Thanks in advance.
Regards,
Ben
can somebody please help me?
Something is wrong with this dlookup in :
Code:
strSQL = "Update TNS Set TNS_in_TRY = " & _
" Nz([TNS_in_TRY],0) + " & Str(a) & " * Dlookup([TNS_in_TRY],TNS,Division = 'COMMON' AND Product_Class = 'Scrap_Sales' AND Reporting_Month = '" & t & "') " &
" Where Division IN ('AK') AND Product_Class = 'Scrap Sales' AND Reporting_Month = '" & t & "'"
I debugged a and t these variables are correct.
Thanks in advance.
Regards,
Ben