Hi
I am new to Ms access. I am setting the control source property for a text box say txt1. I am trying to display sum of expense amount where bill number is equal to that of bill number displayed on form.
Here is the expression that i used for this.
=DLookUp([SUM("Expense Amount");"tblExpenses";[tblExpenses]![BillNo]=[Forms]![frmExpenses]![txtBillNo])
I am getting Name?# error.
Could you please let me know what is going wrong
Thanks