OK thanks so much Bulzie, I think this has helped me get onto the correct path
I created this query. Its made up of a table and a query. Heres the code. It seems to run but displays nothing. What have I done wrong do you think?
Code:
SELECT Options.Option, Sum(IIf([Option]=[First Of Number and Place Value],1,0)) AS NumberandplacevalueCount, Sum(IIf([Option]=[First Of Addition and Subtraction],1,0)) AS AdditionandSubtractionCount, Sum(IIf([Option]=[First Of Multiplication and Division],1,0)) AS MultiplicationandDivisionCount, Sum(IIf([Option]=[First Of Fractions],1,0)) AS FractionsCount, Sum(IIf([Option]=[First Of Measurement],1,0)) AS MeasurementCount, Sum(IIf([Option]=[First Of Geometry],1,0)) AS GeometryCountFROM Options, [STUDENT BIO Query]
WHERE ((([STUDENT BIO Query].[SEN Status])="SEN Suport"))
GROUP BY Options.Option;
The above code doesn't work but the following code below does, based on 2 tables to make this SQL query. Why can't I get this to work with the SEN part? (I am aware the titles of some of the fields are different with first of included but thats what they are called in the query i'm using with the new SQL above so thats correct
Code:
SELECT Options.Option, Sum(IIf([Option]=[Number and Place Value],1,0)) AS NumberandplacevalueCount, Sum(IIf([Option]=[Addition and Subtraction],1,0)) AS AdditionandSubtractionCount, Sum(IIf([Option]=[Multiplication and Division],1,0)) AS MultiplicationandDivisionCount, Sum(IIf([Option]=[Fractions],1,0)) AS FractionsCount, Sum(IIf([Option]=[Measurement],1,0)) AS MeasurementCount, Sum(IIf([Option]=[Geometry],1,0)) AS GeometryCountFROM Options, Strands
GROUP BY Options.Option;
Why does this one work but the very top one not?
Thanks again for any help here