G
Guest
A mate of mine recently posted a question that was given us a bit of
difficulty. We had a calculated field named FTE that maybe causing the issue,
as it isn't an actual data field. So we are going the subquery route. I've
done similar before but seem to be having some issues this time around. I've
included what I have below:
SELECT [FTE-SVTRA].[Employee Name], [FTE-SVTRA].[WK GP], [FTE-SVTRA].FTE
FROM [FTE-SVTRA];
Thanks for taking a look.
difficulty. We had a calculated field named FTE that maybe causing the issue,
as it isn't an actual data field. So we are going the subquery route. I've
done similar before but seem to be having some issues this time around. I've
included what I have below:
SELECT [FTE-SVTRA].[Employee Name], [FTE-SVTRA].[WK GP], [FTE-SVTRA].FTE
FROM [FTE-SVTRA];
Thanks for taking a look.