Ok then.

I had built the table tblEmp with fields

Emp id -Auto Number
Emp Name- Text
Date of Joining -Date/time.
Days worked- Number
Amount earned-Currency

Regarding the

RowSource:i had created a SQL Query name qryemp,where the query returned
only the Employees name from tblemp

Control Source:=DSum("[Amount Earned]","[EMP]","[Emp id] = " & [Emp Name])

Bound Column:not sure which column i should refer 2/5.

Also , please tell me ,can i upload the file to your reference.

Thanks in advance.....