Unanswered: Problems getting numbers to match up in query
I am hacking up a database that someone else made. This is for inventory counting dollar value.
What I'm trying to do is have it return to me if something was adjusted out in 2009 then adjusted back in in 2010. This would show up as a negative dollar value in 09 and a positive of the same amount in 10.
I thought I had it but here is what it would do:
From table 2009
From Table 2010
Whenever I try to make a query it gives me something like this:
Material Variance09 Variance10
1234567 -123 123
1234567 -123 0
1234567 15 123
1234567 15 0
How can I set this up so it actually gives me what I want? Here are pics of the queries I'm basing this off of:
In an otherwise well constructed question you've shown us everything apart from what you actually want!
oh yeah lol
I want it to only show if something was adjusted out, and the same dollar value was adjusted back in. Where I get stuck is when a Material number is multiplied out because there are different values in each table.