Not having luck adding a second table to a query

[nick1408]

I'm trying to add [RICTweek]![NPS Per Week] to the query [Weekly Predicted Effort] but as soon as I do it throws all the sums out. Is there a way I can add this column so I can graph it?

Thanks!

 

[JHB]

Could you show a printscreen of what you want?

 

[nick1408]

The above is what I have. I want a second number column that shows the contents of either table RICTWeek or query Weekly Baseline NPS shown against the equivalent date. This is how I tried to set it up:

As you can guess it didn't work

 

[The_Doc_Man]

but as soon as I do it throws all the sums out.

Try to say in words what you expected to see and what you actually saw. It looks to me that you had a GROUP BY with two fields being grouped (perfectly legal, by the way). The sums would be based on the inner group (last-named GROUP BY) rather than the outer group (first-named GROUP BY) so if you ADDED a new group, I would NOT expect it to NOT change (sorry for the double negative - it was for emphasis.)

 

[JHB]

The above is what I have. I want a second number column that shows the contents of either table RICTWeek or query Weekly Baseline NPS shown against the equivalent date. This is how I tried to set it up:

I would like to see the result you want, (the values in the 3 fields)!

 

[nick1408]

I have this query working as I expect and want it to also show on the query above.

This:

gives me this:

Granted, I have done this on the Weekly Baseline NPS query but the details should be the same whether I have it on this one or the original one. I would prefer to do it on the query you quoted previously.

 

[nick1408]

Here is another example on the query I am actually wanting all this on:

As you can see from the original picture the sums are no longer correct. I am referenceing the querys wrong, I just don't know what I am doing wrong

 

[JHB]

Is this the result you're looking for?

 

[jdraw]

nick1408,

Please tell us in 5-6 lines of plain English -no jargon -what the business underlying your database is?
At this point responders are trying to guess what you're doing/trying to accomplish.

So in simple terms -as you would tell an 8 yer old, what are you trying to do?

There is an old adage with programming:
....if you can't describe it, no one can build it....

 

[nick1408]

Is this the result you're looking for?

That is almost it but I see 10/12 is being repeated. Is it possible to have all the results for 10/12 on one line so 10/12 would be 124 for sum of total effort and 6 for NPS per week? I feel both columns need to be sums

 

[JHB]

That is almost it but I see 10/12 is being repeated. Is it possible to have all the results for 10/12 on one line so 10/12 would be 124 for sum of total effort and 6 for NPS per week?

That is easy, just create a query that sums the 2 fields (columns).

...I feel both columns need to be sums

You write you feel it, does that mean you do not know if that is correct or not?
Database attached, run the query "TheSumQuery".