Add Fields to a query that are not included in an aggregate functi

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

I have a query with aggegated functions.

SELECT Count(Classified) AS TotCnt, Abs(Sum(classified=-1)) AS
TrueCnt_Unclassified, TrueCnt_Unclassified/TotCnt AS
PerCentTrue_Unclassified, Abs(Sum(classified=0)) AS TrueCnt_Active,
TrueCnt_Active/TotCnt AS PerCentTrue_Active
FROM DataTable;

If I wanted to add other fields to the query how to I go about doing that.
For example say I wanted to add the "Date" field to the query. How would I do
that?
Thanks in advance!
 
If you are talking about just adding a new field titled "date"you can add
this to the select statement:

, Date: as ''

That's two single quotation marks.
 
Do you mean like this --
SELECT Count(Classified) AS TotCnt, Abs(Sum(classified=-1)) AS
TrueCnt_Unclassified, TrueCnt_Unclassified/TotCnt AS
PerCentTrue_Unclassified, Abs(Sum(classified=0)) AS TrueCnt_Active,
TrueCnt_Active/TotCnt AS PerCentTrue_Active, Date() AS Report_Date
FROM DataTable
GROUP BY TrueCnt_Unclassified/TotCnt, TrueCnt_Active/TotCnt, Date();
 
I have a query with aggegated functions.

SELECT Count(Classified) AS TotCnt, Abs(Sum(classified=-1)) AS
TrueCnt_Unclassified, TrueCnt_Unclassified/TotCnt AS
PerCentTrue_Unclassified, Abs(Sum(classified=0)) AS TrueCnt_Active,
TrueCnt_Active/TotCnt AS PerCentTrue_Active
FROM DataTable;

If I wanted to add other fields to the query how to I go about doing that.
For example say I wanted to add the "Date" field to the query. How would I do
that?
Thanks in advance!
Click to expand...

If your query retrieves multiple records, with multiple date values, what do
you want to see? Or are you talking about displaying today's date?
 
Back
Top