If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Sum & Count on Form.
i had a form on which i had created a combo box that contain several employees.
I want the amount earned (Currency Format) by each employee to be displayed on the formin the text box. Other fields in my table are; Empid,Empname,amount earned.etccc please tell me how to solve this. |
#2
|
|||
|
|||
Sum & Count on Form.
I mean i want the sum to be displayed in the text box whenever i select an
employee from the combo box. |
#3
|
|||
|
|||
Sum & Count on Form.
On Tue, 18 May 2010 20:56:01 -0700, Chiki
wrote: i had a form on which i had created a combo box that contain several employees. I want the amount earned (Currency Format) by each employee to be displayed on the formin the text box. Other fields in my table are; Empid,Empname,amount earned.etccc please tell me how to solve this. Well, it's a bit hard to be sure given the sparse information, but try setting the control source of the textbox to =DSum("[Amount Earned]", "tablename", "[EmpID] = " & [EmpID]) -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Sum & Count on Form.
Is it so difficult???
Please tell me what other information do i need to provide Thanks |
#5
|
|||
|
|||
Sum & Count on Form.
On Wed, 19 May 2010 03:47:01 -0700, Chiki
wrote: Is it so difficult??? Please tell me what other information do i need to provide Thanks Did you see my previous answer? try setting the control source of the textbox to =DSum("[Amount Earned]", "tablename", "[EmpID] = " & [EmpID]) -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Sum & Count on Form.
Yes, i had tried using the formula u had given.
Its returning an #Error Message.I dont know why.I think i had to check out the exact syntax or check the correct text box names. Thanks. |
#7
|
|||
|
|||
Sum & Count on Form.
On Wed, 19 May 2010 19:51:01 -0700, Chiki
wrote: Yes, i had tried using the formula u had given. Its returning an #Error Message.I dont know why.I think i had to check out the exact syntax or check the correct text box names. Thanks. Well... yes. I cannot see your screen. I do not know the name of your table; you should use it in place of "tablename". Likewise you need to specify the correct fieldnames... which, again, I do not know. If you'll post some more details about your table (table name, fieldnames, datatypes of those fields, form control names) someone should be able to help. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|