dbaker5204
Registered User.
- Local time
- Today, 15:47
- Joined
- Jan 19, 2018
- Messages
- 20
I have a query which contains 3 tables and I am running into a problem where the query eliminates data that isnt included in one of the tables that I have linked. I tried changing the relationship link so that it would show everything from the one table and the fields from the other table that were equal and I get the follow error:
The SQL Statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement. Well, I tried this and the data is still being eliminated- perhaps I am not doing it correctly...
I have a a table that has cases logged (tbl_MSP_Cases), a table that has all the agents names in it (tbl_MSP_RepNames) and a table that has the number of calls the agents took (tbl_MSP_CMS_AgentData). What is happening is, if agents dont log their calls, the whole day does not show up for them. I want it to show, but just show a blank for calls logged. The rep table needs to be included because the way the data feeds over, the agent names are not formatted the same in the other two tables.
Any help would be appreciated.
The SQL Statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement. Well, I tried this and the data is still being eliminated- perhaps I am not doing it correctly...
I have a a table that has cases logged (tbl_MSP_Cases), a table that has all the agents names in it (tbl_MSP_RepNames) and a table that has the number of calls the agents took (tbl_MSP_CMS_AgentData). What is happening is, if agents dont log their calls, the whole day does not show up for them. I want it to show, but just show a blank for calls logged. The rep table needs to be included because the way the data feeds over, the agent names are not formatted the same in the other two tables.
Any help would be appreciated.