Hi,
I am sure I am missing something fairly simple here?
I have 2 tables called 6000EquipmentDetails and Order Details, They share some common fields but are not related. The 6000EquipmentDetails table shows project equipment details, all the ID fields are foreign keys in both tables. ProjectID, EquipmentID, EquipmentCategoriesID and CompletionID etc, I will use CompletionID to determine whether a piece of equipment is actually installed. The Order Details table carries all the information about the equipment that has been supplied to the project ProjectID, EquipmentID, OrderID. Quantity etc.
I have a form called Stock Dashboard where I want to place a subform from which I can see by ProjectID the difference between the Equipment I have used and the equipment supplied. In effect the equipment totals unused and available to the project.
I am not that new to access but I am self teaching and becoming familiar with the language. I have experimented with joins and a Union Query where I cant seem to divide a combined CountOfEquipmentID(6000EquipmentID) and Quantity(Order Details) field which gives me both sets of values. there are nulls where a project is ongoing but hasn't had a delivery of equipment which I think may be part of the problem.
I hope I have explained this clearly and I am truly thankful for any direction, thankyou in advance
I am sure I am missing something fairly simple here?
I have 2 tables called 6000EquipmentDetails and Order Details, They share some common fields but are not related. The 6000EquipmentDetails table shows project equipment details, all the ID fields are foreign keys in both tables. ProjectID, EquipmentID, EquipmentCategoriesID and CompletionID etc, I will use CompletionID to determine whether a piece of equipment is actually installed. The Order Details table carries all the information about the equipment that has been supplied to the project ProjectID, EquipmentID, OrderID. Quantity etc.
I have a form called Stock Dashboard where I want to place a subform from which I can see by ProjectID the difference between the Equipment I have used and the equipment supplied. In effect the equipment totals unused and available to the project.
I am not that new to access but I am self teaching and becoming familiar with the language. I have experimented with joins and a Union Query where I cant seem to divide a combined CountOfEquipmentID(6000EquipmentID) and Quantity(Order Details) field which gives me both sets of values. there are nulls where a project is ongoing but hasn't had a delivery of equipment which I think may be part of the problem.
I hope I have explained this clearly and I am truly thankful for any direction, thankyou in advance
