Attached are four Word documents. The docs entitled "ITEMAGEPOS" and "ITEMAGENEG" represent CTEs. The other two docs are screenshots showing samples of results from running either CTE.
I'd like to place "ITEMAGEPOS" in a view. And, in that view, I'd like to add the [Quantity Remaining] field from "ITEMAGENEG" to the Quantity Remaining field of "ITEMAGEPOS" for every match of [Item Number], [Location Code], and [Date Range] in "ITEMAGEPOS".
How do I accomplish both of these tasks?
I'm probably going to have to create a view for "ITEMAGENEG", ad well. But, the only data that I want from "ITEMAGENEG" to be "within" "ITEMAGEPOS" is [Quantity Remaining].
Thanks! Much appreciated!