G
Guest
In executing the following query:
SELECT CurrentData.[VacRate], EmpData.[HireDate], SUM(TimeOff.[Hours]) AS
HoursTaken
FROM CurrentData, EmpData, TimeOff
WHERE CurrentData.[FileNum] = filenum* AND EmpData.[FileNum] = filenum* AND
TimeOff.[FileNum] = filenum*
I get the following message:
"You tried to execute a query that does not include the specified expression
'VacRate' as part of an aggregate function".
I don't want 'VacRate' in the SUM function, only all the Hours for a given
employee.
Thanks in advance.
SELECT CurrentData.[VacRate], EmpData.[HireDate], SUM(TimeOff.[Hours]) AS
HoursTaken
FROM CurrentData, EmpData, TimeOff
WHERE CurrentData.[FileNum] = filenum* AND EmpData.[FileNum] = filenum* AND
TimeOff.[FileNum] = filenum*
I get the following message:
"You tried to execute a query that does not include the specified expression
'VacRate' as part of an aggregate function".
I don't want 'VacRate' in the SUM function, only all the Hours for a given
employee.
Thanks in advance.