Hi everyone!
I need help regarding subtracting two values from two queries. I have search around and found some examples, but I could not make them work with mine because it involves SQL statements and I'm not that familiar with them.
Basically I have two queries that sums up the value from two tables. The following queries have the following fields in them.
qryQuantityA
-InvoiceID (Grouped)
-ProductID (Grouped)
-TotalQuantity (Sum)
qryQuantityB
-InvoiceID (Grouped)
-ProductID (Grouped)
-TotalQuantity (Sum)
I would like to subtract the fields "qryQuantityB.TotalQuantity" to "qryQuantityA.TotalQuantity" with InvoiceID criteria to be "1234."
I know I will indeed have to write it in SQL but I'm totally at a lost on what to do, I can add both tables, no problem, but could not make them subtract each other.
Thanks.
I need help regarding subtracting two values from two queries. I have search around and found some examples, but I could not make them work with mine because it involves SQL statements and I'm not that familiar with them.
Basically I have two queries that sums up the value from two tables. The following queries have the following fields in them.
qryQuantityA
-InvoiceID (Grouped)
-ProductID (Grouped)
-TotalQuantity (Sum)
qryQuantityB
-InvoiceID (Grouped)
-ProductID (Grouped)
-TotalQuantity (Sum)
I would like to subtract the fields "qryQuantityB.TotalQuantity" to "qryQuantityA.TotalQuantity" with InvoiceID criteria to be "1234."
I know I will indeed have to write it in SQL but I'm totally at a lost on what to do, I can add both tables, no problem, but could not make them subtract each other.
Thanks.