Sum & Count on Form.
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.....
|