I have three textboxes...
1.) p_principal
2.) p_balance
3.) p_payment
at first payment the balance would be p_balance=p_principal-p_payment...
How if the customer will pay again? how to update the formula to p_balance=p_balance-p_payment?
so can I use the query to create reports instead of the table since the my query holds the complete details of my form?
THANKS AGAIN...
May GOD BLESS YOU and your FAMILY
thanks... I did'nt delete the table.. but now,,,, the calculated fields in the form automatically reflects in my query but not in my table... is it normal???
I have done making a query of that table and put the formulas/expressions on some fields... my problem is how can i put the calculated values from query to my form and connected it again to my table???
I typed this in the third box:
= Datediff("d", [d_dgranted], [d_dmaturity])
and it computed the difference of the two dates in two textboxes..
The two textboxes are connected in a table... and I want also the third box to be connected on that table..
But how can I do this since I typed the...
yes thanks to all of you... I typed this in a third textbox:
=DateDiff("d",[d_dgranted],[d_dmaturity])
It worked...
But my other problem is how can i connect this now into my table ???
Hi...
I have two forms with two textboxes:
The first textbox asks for the beginning date while the second textbox asks for the end date.
These two textboxes are formatted and masked as "short date".
Then I created a third textbox that must automatically display the number of days between the...
Hello this is my first ! Thanks GOD for bringing me here... :)
By the way, I had this problem of displaying a report in MS ACCESS 2003:
I want to display a report where in the user will input a beginning date and an end date. I hope you get what I mean