D
deen
Hi all,
In access i have 2 table name main and paid details,
based on this table i has create the form also. bcoz the both form
have with relation ship
1. Main table contains,
RegCode Name Add DOJ DOB
001 dee sjh 2/04/89 20/08/70
002 aha try 12/10/2004 21/08/80
In this table regcode as set for primarykey
2. Paid Details Tble contains
Regcode1 paiddate amount
001 2/04/08 500
001 03/07/06 600
002 03/09/06 6000
001 14/10/01 4500
002 12/07/05 6500
in this table(paid details) lot of same regcode has been repeated.
doubt:
I already done the form creation.
but i have trouble with sum the certain values in paid details form
footer.
i need the result in form footer,in form reg code is 001 means in form
footer
text bot it show sum of 001 (5600)
i allready try below formula also but there is no reponses.
=Sum(Dlookup("[Amount]", "Paid Details", "[Reg Code]= '" &
[Reg Code] & "'"))
=Sum(Nz(Dlookup("[Amount]", "[Paid Details]", "[Reg Code]= '" & [Reg
Code] &
"'")))
=DSum("[Amount]", "[Paid Details]", "[Reg Code]= '" & [Reg Code] &
"'")
can anyone help me on this
Am very new to access pls help me on this.
Regards,
Deen
In access i have 2 table name main and paid details,
based on this table i has create the form also. bcoz the both form
have with relation ship
1. Main table contains,
RegCode Name Add DOJ DOB
001 dee sjh 2/04/89 20/08/70
002 aha try 12/10/2004 21/08/80
In this table regcode as set for primarykey
2. Paid Details Tble contains
Regcode1 paiddate amount
001 2/04/08 500
001 03/07/06 600
002 03/09/06 6000
001 14/10/01 4500
002 12/07/05 6500
in this table(paid details) lot of same regcode has been repeated.
doubt:
I already done the form creation.
but i have trouble with sum the certain values in paid details form
footer.
i need the result in form footer,in form reg code is 001 means in form
footer
text bot it show sum of 001 (5600)
i allready try below formula also but there is no reponses.
=Sum(Dlookup("[Amount]", "Paid Details", "[Reg Code]= '" &
[Reg Code] & "'"))
=Sum(Nz(Dlookup("[Amount]", "[Paid Details]", "[Reg Code]= '" & [Reg
Code] &
"'")))
=DSum("[Amount]", "[Paid Details]", "[Reg Code]= '" & [Reg Code] &
"'")
can anyone help me on this
Am very new to access pls help me on this.
Regards,
Deen