I have the following DLookup expression in a textbox control
=Sum(DLookUp("[balance]","[FinanceDeals]","[Company]='Haydock' AND [Status] ='Confirmed'"))
I want to add another condition which is, AND [month_in_FinanceDeals_table] = value_of_textbox_on_my_form
The textbox is called 'month' same as the fieldname in the table.
What would the expression be?
Thanks
=Sum(DLookUp("[balance]","[FinanceDeals]","[Company]='Haydock' AND [Status] ='Confirmed'"))
I want to add another condition which is, AND [month_in_FinanceDeals_table] = value_of_textbox_on_my_form
The textbox is called 'month' same as the fieldname in the table.
What would the expression be?
Thanks