G
Guest
I got this error message while trying to execute a query.
The query is a based upon a merger of a crosstab query and a table from the
SQL server. The error occurs in my subquery statement to create a running
balance.
The specified expression the it has a problem with was "" as part of the
aggregate function.
The subquery went something like this:
MTDHRs: (Select sum(Dupe.Reghours) FROM qryAllHours AS Dupe WHERE
(Dupe.BatchID between [Starting] AND [Ending]) AND (Dupe.[Dept]
=qryAllHours.[Dept]) AND (Dupe.[Job] = qryAllHours.[Job]) AND (Dupe.BatchID<=
qryAllHours.[BatchID]))
I am trying to generate a running total from qryAllhours by batchID, by
Dept, and by Job. The error occurs with the two WHERE conditions for the
Dept and Job. The query otherwise runs fine without them.
The exact error message goes:
You tried to execute a query that does not include the specified expression
'' as part of an aggregate function.
Any ideas where to start. The crosstab table is fine and there is always a
value for Dept AND for Job.
The query is a based upon a merger of a crosstab query and a table from the
SQL server. The error occurs in my subquery statement to create a running
balance.
The specified expression the it has a problem with was "" as part of the
aggregate function.
The subquery went something like this:
MTDHRs: (Select sum(Dupe.Reghours) FROM qryAllHours AS Dupe WHERE
(Dupe.BatchID between [Starting] AND [Ending]) AND (Dupe.[Dept]
=qryAllHours.[Dept]) AND (Dupe.[Job] = qryAllHours.[Job]) AND (Dupe.BatchID<=
qryAllHours.[BatchID]))
I am trying to generate a running total from qryAllhours by batchID, by
Dept, and by Job. The error occurs with the two WHERE conditions for the
Dept and Job. The query otherwise runs fine without them.
The exact error message goes:
You tried to execute a query that does not include the specified expression
'' as part of an aggregate function.
Any ideas where to start. The crosstab table is fine and there is always a
value for Dept AND for Job.