Help with a query?

[tamer64]

Can someone explain to me what this mean and how do correct the query?
"You tried to execute a query that does not include the specified expression "Barcode Assignment" as part of the aggregate function"


SELECT Test2.Barcode_Assignment, Format((Sum([ Test2]![SumOfTotal_Time])-Int(Sum([Test2]![SumOfTotal_Time]))),"hh:nn:ss") AS New
FROM Test2;

 

[tamer64]

Doing a little research...I understand. Problem solved.

 

[lameid]

In case anyone is searching the net for an Answer, the use of the aggregate sum means that all fields have to be used in either an aggregate function or in a group by clause.

SELECT Test2.Barcode_Assignment, Format(([red]Sum[/red]([ Test2]![SumOfTotal_Time])-Int(Sum([Test2]![SumOfTotal_Time]))),"hh:nn:ss") AS New
FROM Test2
Group By [red]Test2.Barcode_Assignment;[/red]