Calculation Help, Either Query or Crosstab

[mweisler20]

I'm having a bit of a problem trying to figure out the right calculation to my own question. Overall I'm trying to get two answer's from one big query that was pulled on a selection of dates. I believe it would be easier you open the access database attached and look under my Help query, everything else that's in there is just non sense just part of my overall bigger program.


But the end result that i'm looking for is this

If I selected and Effect of "2.2" in the Query How many are there total and what is the overall value of them. So like in the help Query I would have (Two 2.2 Effects, with and overall value of 4) This query is rather small compared to my bigger one, and i'm looking for something that can calculate this a little bit faster then having to find all the "2.2" effects if I had 150+ rows to look through.


Thank you for your help

mweisler20Calculation help.accdb

[June7]

Do you need to add criteria under [Effects and Objectives].Effects of: =[Date Picker]![Effect]?

The result for this sample data would be one record.

If you want to know the count of records and the sum of Effects, do a GROUP BY (Totals) query. However, this will not allow the display of other detail info. Build a report to allow that. Or do a Totals row on the filtered query. With query in Datasheet view, click the Totals button on ribbon Home tab. This will open a row where can select aggregate functions under each field.