I don't know if this should be posted in tables,querry,form or records, so i want to apologize ahead of time.
I have 2 tables, "tblProducts" & "tblInventory" that have a relationship of one to many using the ItemID. What I need accomplish is to get a grand total of the value of all products. I don't know how to accomplish this. I know i have the ProductID in both of these tables. I have the available stock in the the table, "tblInventory" under the control "Available" and i have the cost of all the products in the table, "tblProducts" under the control "ListPrice". How do I do this calculation and what do i use a form, querry, records? Do I need to make a control in a table? Thanks ahead of time.
Thanks
James
I have 2 tables, "tblProducts" & "tblInventory" that have a relationship of one to many using the ItemID. What I need accomplish is to get a grand total of the value of all products. I don't know how to accomplish this. I know i have the ProductID in both of these tables. I have the available stock in the the table, "tblInventory" under the control "Available" and i have the cost of all the products in the table, "tblProducts" under the control "ListPrice". How do I do this calculation and what do i use a form, querry, records? Do I need to make a control in a table? Thanks ahead of time.
Thanks
James
