klynch0803
Registered User.
- Local time
- Today, 01:32
- Joined
- Jan 25, 2008
- Messages
- 102
I have a form "fdatPayEmp" that has fields "WeekStart" "WeekEnd" "GrossPurchase"
I have a table "tdatPurchases" that has Fields "ChkDate" "ChkAmt".
I want to get the total of the ChkAmt for the reange of dates entered on form and have the value placed in "GrossPurchase"
If either of the dates are changed I want the value to update as well so I guess if I use a subform I may have to hae a refresh or something to complete this.
I want to do it by code but it appears that I am going to have to do a query or something. Can someone tell me what I need to do kinda step by step to do this?
I have a table "tdatPurchases" that has Fields "ChkDate" "ChkAmt".
I want to get the total of the ChkAmt for the reange of dates entered on form and have the value placed in "GrossPurchase"
If either of the dates are changed I want the value to update as well so I guess if I use a subform I may have to hae a refresh or something to complete this.
I want to do it by code but it appears that I am going to have to do a query or something. Can someone tell me what I need to do kinda step by step to do this?
Last edited:
