Query Totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following query. I need to add more fields to this query, but
when I do they also have a "Group By" total. I want the fields that I
currently have in the query to be Grouped by and then I'd like to add more
fields that are not grouped because I want to see all of those records, not
group them. Is there a way to do this? Thank you

SELECT SASNoDemoutTwo.MODEL, SASNoDemoutTwo.TOPLEVEL, SASNoDemoutTwo.PARTA,
SASNoDemoutTwo.PARTB, SASNoDemoutTwo.PARTC, SASNoDemoutTwo.PARTD,
SASNoDemoutTwo.PARTE, SASNoDemoutTwo.PARTF, SASNoDemoutTwo.PARTG,
SASNoDemoutTwo.PARTH, SASNoDemoutTwo.PARTI, Max(SASNoDemoutTwo.NPIEC) AS
MaxOfNPIEC
FROM SASNoDemoutTwo
GROUP BY SASNoDemoutTwo.MODEL, SASNoDemoutTwo.TOPLEVEL,
SASNoDemoutTwo.PARTA, SASNoDemoutTwo.PARTB, SASNoDemoutTwo.PARTC,
SASNoDemoutTwo.PARTD, SASNoDemoutTwo.PARTE, SASNoDemoutTwo.PARTF,
SASNoDemoutTwo.PARTG, SASNoDemoutTwo.PARTH, SASNoDemoutTwo.PARTI
ORDER BY SASNoDemoutTwo.MODEL, SASNoDemoutTwo.TOPLEVEL,
SASNoDemoutTwo.PARTA, SASNoDemoutTwo.PARTB, SASNoDemoutTwo.PARTC,
SASNoDemoutTwo.PARTD, SASNoDemoutTwo.PARTE, SASNoDemoutTwo.PARTF,
SASNoDemoutTwo.PARTG, SASNoDemoutTwo.PARTH, SASNoDemoutTwo.PARTI;
 
Alex said:
I have the following query. I need to add more fields to this query, but
when I do they also have a "Group By" total. I want the fields that I
currently have in the query to be Grouped by and then I'd like to add more
fields that are not grouped because I want to see all of those records, not
group them. Is there a way to do this? Thank you

SELECT SASNoDemoutTwo.MODEL, SASNoDemoutTwo.TOPLEVEL, SASNoDemoutTwo.PARTA,
SASNoDemoutTwo.PARTB, SASNoDemoutTwo.PARTC, SASNoDemoutTwo.PARTD,
SASNoDemoutTwo.PARTE, SASNoDemoutTwo.PARTF, SASNoDemoutTwo.PARTG,
SASNoDemoutTwo.PARTH, SASNoDemoutTwo.PARTI, Max(SASNoDemoutTwo.NPIEC) AS
MaxOfNPIEC
FROM SASNoDemoutTwo
GROUP BY SASNoDemoutTwo.MODEL, SASNoDemoutTwo.TOPLEVEL,
SASNoDemoutTwo.PARTA, SASNoDemoutTwo.PARTB, SASNoDemoutTwo.PARTC,
SASNoDemoutTwo.PARTD, SASNoDemoutTwo.PARTE, SASNoDemoutTwo.PARTF,
SASNoDemoutTwo.PARTG, SASNoDemoutTwo.PARTH, SASNoDemoutTwo.PARTI
ORDER BY SASNoDemoutTwo.MODEL, SASNoDemoutTwo.TOPLEVEL,
SASNoDemoutTwo.PARTA, SASNoDemoutTwo.PARTB, SASNoDemoutTwo.PARTC,
SASNoDemoutTwo.PARTD, SASNoDemoutTwo.PARTE, SASNoDemoutTwo.PARTF,
SASNoDemoutTwo.PARTG, SASNoDemoutTwo.PARTH, SASNoDemoutTwo.PARTI;
Click to expand...

You can't have ungrouped fields becuase you are using an aggregate function
(Max)
 
Back
Top