Dear Sirs,
I have a Table "total Cmp" in which the fields are finyear,section. Chamt and settlement_date
I want to get the value of total amount in the filed Chamt by cliking a command button and display the result in a textbox TCMP
I am using the code below but I am getting error type mismatch
Me.TCMP.value = FormatIndian(Nz(DSum("Chamt", "total cmp", "finyear = " & [COMFY] & " and section = " & [TXTUC] And "[settelment_date] between [Text0] and [Combo4]")))
please help me
I have a Table "total Cmp" in which the fields are finyear,section. Chamt and settlement_date
I want to get the value of total amount in the filed Chamt by cliking a command button and display the result in a textbox TCMP
I am using the code below but I am getting error type mismatch
Me.TCMP.value = FormatIndian(Nz(DSum("Chamt", "total cmp", "finyear = " & [COMFY] & " and section = " & [TXTUC] And "[settelment_date] between [Text0] and [Combo4]")))
please help me