Repeating values? (1 Viewer)

[illusion14]

Hello,I can't seem to be figuring out what is going wrong. The situation I have is I currently have 2 rows of data with one being current revenue and the other being current cost, basically when i run the Quary Wizard, i do
Total Revenue:[current revenue]-[current cost]
However the issue i am running into is it matches up each individual value to one another so for example if the current revenue is 150 it will match it to each week instead of just doing the current week
For Ex: 150-100=50(currently week 1)
150-20=130(even though week 2 is only 100 for the revenue)
This goes on for ever revenue value.Basically I just want to match the weekly revnue to the weekly cost.This seems simple enough but I just can't seem to figure it out, any help would be appreciated. Thanks guys

 

[lightray]

Would need to know how each table is structured to be able to get a better understanding of your problem.