Hi All
I have two tables 1. tblBudgets and 2 tblMaterial_Purchase_Request and one form "frmBudgets"
The tblbudgets is a single record table which contains the 2019 budgets. example
ID
Fin_Year
Insurance
Stationary
When the form opens using the about table, i put the budgets in the single record table. example
Fin Year 2019
Insurance 10,000
Stationary 2,000
The second table "tblMaterial_Purchase_Request" is a Purchase order transactions table, there are lots of transaction purchase order records in there.
ID
Transaction_Type Text
Qty number
Item_Cost Currency
PO_Total_Amount Currency
Form (frmBudgets) see attached.
Fin Year 2019
Insurance 10,000 [total of tblMaterial_Purchase_Request = Insurance] ??
Stationary 2,000 [total of tblMaterial_Purchase_Request = Stationery] ??
I am struggling to get the frmbudgets to create a text box that will show the "total of tblMaterial_Purchase_Request = Insurance"
tried sql query, sum, dsum its just not working.
Anyone out there that can help would appreciate it.
Terry
Thanking you in advance.
I have two tables 1. tblBudgets and 2 tblMaterial_Purchase_Request and one form "frmBudgets"
The tblbudgets is a single record table which contains the 2019 budgets. example
ID
Fin_Year
Insurance
Stationary
When the form opens using the about table, i put the budgets in the single record table. example
Fin Year 2019
Insurance 10,000
Stationary 2,000
The second table "tblMaterial_Purchase_Request" is a Purchase order transactions table, there are lots of transaction purchase order records in there.
ID
Transaction_Type Text
Qty number
Item_Cost Currency
PO_Total_Amount Currency
Form (frmBudgets) see attached.
Fin Year 2019
Insurance 10,000 [total of tblMaterial_Purchase_Request = Insurance] ??
Stationary 2,000 [total of tblMaterial_Purchase_Request = Stationery] ??
I am struggling to get the frmbudgets to create a text box that will show the "total of tblMaterial_Purchase_Request = Insurance"
tried sql query, sum, dsum its just not working.
Anyone out there that can help would appreciate it.
Terry
Thanking you in advance.