Fill Form using strsql or Select

[klynch0803]

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.

 

[ajetrumpet]

try this for starters....