C
Chris
Hi,
I'm stumped to why this doesn't work now.
We originally had our staff calendar in Access, I've been asked to move our
tables to Sharepoint.
So I've done this, and relinked the tables/lists to our Access Front End.
I have almost everything working, but now I'm running into a problem with
one of my queries.
This query would display every employee, and then list the supervisor for
the employee.
To do this, I used the EmployeeName table twice in the query. ONce to get
the employee name, and then used an alias to get the supervisor name.
The query looked like this
SELECT EmployeeName.EmployeeName, Team_Name.Team,
EmployeeName_1.EmployeeName AS Supervisor
FROM (EmployeeName LEFT JOIN Team_Name ON EmployeeName.DeptID =
Team_Name.ID) LEFT JOIN EmployeeName AS EmployeeName_1 ON
EmployeeName.Supervisor_Manager = EmployeeName_1.ID;
When I run this query against the tables in Access, it worked great. But
now running it against the linked Sharepoint tables, it doesn't work at all.
It will sometimes list employees multiple times, one time I got a records
set of 30k, when we only have a 160 total staff.
One thing I noticed is, when I run the query in Access. The alias
(supervisor) appears as a column header. But when I run it against
Sharepoint, it doesn't list supervisor anymore, it says EmployeeName. So
it's acting like it's not accepting it as an alias.
Any ideas how to fix this?
Thanks
I'm stumped to why this doesn't work now.
We originally had our staff calendar in Access, I've been asked to move our
tables to Sharepoint.
So I've done this, and relinked the tables/lists to our Access Front End.
I have almost everything working, but now I'm running into a problem with
one of my queries.
This query would display every employee, and then list the supervisor for
the employee.
To do this, I used the EmployeeName table twice in the query. ONce to get
the employee name, and then used an alias to get the supervisor name.
The query looked like this
SELECT EmployeeName.EmployeeName, Team_Name.Team,
EmployeeName_1.EmployeeName AS Supervisor
FROM (EmployeeName LEFT JOIN Team_Name ON EmployeeName.DeptID =
Team_Name.ID) LEFT JOIN EmployeeName AS EmployeeName_1 ON
EmployeeName.Supervisor_Manager = EmployeeName_1.ID;
When I run this query against the tables in Access, it worked great. But
now running it against the linked Sharepoint tables, it doesn't work at all.
It will sometimes list employees multiple times, one time I got a records
set of 30k, when we only have a 160 total staff.
One thing I noticed is, when I run the query in Access. The alias
(supervisor) appears as a column header. But when I run it against
Sharepoint, it doesn't list supervisor anymore, it says EmployeeName. So
it's acting like it's not accepting it as an alias.
Any ideas how to fix this?
Thanks