klynch0803
Registered User.
- Local time
- Today, 15:55
- Joined
- Jan 25, 2008
- Messages
- 102
I have never tried this one before so I need a good boost on this one to even get started..
Heres what I want to do. This looks long and complex but its really simple to say and I think that it should be simple to do for someone who actually knows what they are doing in code LOL.. ANy Help would be appreciatted.
I have the following fields that I need to fill on a form automatically. I feel that using code versus queries is going to be the fastedt way to process the data and reduce the number of items in my database background.
On the form:
"WeekStart". "WeekEnd", "SunCom", "MonCom", "TueCom", "WedCom", "ThuCom", "FriCom", "SatCom"
Now I need the following 2 pieces of data:
1.
Table tdatPurchases I want to run a select statement (I ASSUME) and get the "ChkDate" >= than "WeekStart" & <= WeekdayEnd and Sum of "ChkAmt".
2.
Table tdatInventoryUsage and run a select statement (I ASSUME AGAIN) and get "SaleDate" >= than "WeekStart" & <= WeekdayEnd and Sum of "ChkAmt".
I need to subtract Purchases from Sales and place the value in the proper Day field (ie: "SunCom") on the form.
Heres what I want to do. This looks long and complex but its really simple to say and I think that it should be simple to do for someone who actually knows what they are doing in code LOL.. ANy Help would be appreciatted.
I have the following fields that I need to fill on a form automatically. I feel that using code versus queries is going to be the fastedt way to process the data and reduce the number of items in my database background.
On the form:
"WeekStart". "WeekEnd", "SunCom", "MonCom", "TueCom", "WedCom", "ThuCom", "FriCom", "SatCom"
Now I need the following 2 pieces of data:
1.
Table tdatPurchases I want to run a select statement (I ASSUME) and get the "ChkDate" >= than "WeekStart" & <= WeekdayEnd and Sum of "ChkAmt".
2.
Table tdatInventoryUsage and run a select statement (I ASSUME AGAIN) and get "SaleDate" >= than "WeekStart" & <= WeekdayEnd and Sum of "ChkAmt".
I need to subtract Purchases from Sales and place the value in the proper Day field (ie: "SunCom") on the form.
Last edited:
