Syntax error (missing operator) in Query Expression – Union All of 3 tables

Best Microsoft Access Programmer Portland OR

Hey everyone. I’m pretty new to using SQL code in Access, and I’m getting the error Syntax error (missing operator) in Query Expression ‘Mobile Orders’ when attempting to run the Union All of 3 tables (see below,) where Mobile Orders is one of the columns. Long story short, the Union All gives me the best chance of creating an Excel report that provides 100% accurate data that I need, versus other methods that haven’t been working very well.

I’ve used the NULL for certain columns so the # of columns match.

All combos of using Union All of 2 tables works perfectly. Its when adding in the 3rd column where I start getting that error. As far as I can tell, also, all of the various existing columns data types matched.

I’ve reached the end of the Google hunt, at this point, and I’m not sure where to go next. Thanks!

SELECT [Call Insights].[Fiscal Month], [Call Insights].[Date], [Call Insights].[Agent - Call Center Name] AS [Center], [Call Insights].[Agent - Manager] AS [Manager], [Call Insights].[Agent - Supervisor] AS [Supervisor], [Call Insights].[Agent - Full Name] AS [Agent], [Call Insights].[Agent - HR Number] AS [PSID], [Call Insights].[MSO], [Call Insights].[Handled Segments] AS [Calls], [Call Insights].[Total Handle Time (Total Seconds)] AS [Handle Time], [Call Insights].[Talk Time], [Call Insights].[After Call Work], [Call Insights].[Hold], Null AS [Sales], Null AS [Gold], Null AS [Silver], Null AS [Choice], Null AS [Stream], Null AS [Video], Null AS [Bundle], Null AS [2 Play], Null AS [3 Play], Null AS [Work Orders], Null AS [Essentials], Null AS [Internet], Null AS [Voice], Null AS [Mobile Orders] FROM [Call Insights] UNION ALL Select [Sales Insights].[Fiscal Month], [Sales Insights].[Date - Sales Enter Date] AS [Date], [Sales Insights].[Agent - Call Center Name] AS [Center], [Sales Insights].[Agent - Manager] AS [Manager], [Sales Insights].[Agent - Supervisor] AS [Supervisor], [Sales Insights].[Agent - Full Name] AS [Agent], [Sales Insights].[Agent - HR Number] AS [PSID], [Sales Insights].[MSO], Null AS [Calls], Null AS [Handle Time], Null AS [Talk Time], Null AS [After Call Work], Null AS [Hold], [Sales Insights].[Sales], [Sales Insights].[Sales - Gold] AS [Gold], [Sales Insights].[Sales - Silver] AS [Silver], [Sales Insights].[Sales - Choice] AS [Choice], [Sales Insights].[Sales - Stream] AS [Stream], [Sales Insights].[Sales - Video] AS [Video], [Sales Insights].[Sales - Bundle - Acquistion] AS [Bundle], [Sales Insights].[Sales - Bundle - 2 - Play Acquistion] AS [2 Play], [Sales Insights].[Sales - Bundle - 3 - Play Acquistion] AS [3 Play], [Sales Insights].[Count (Work Order Number)] AS [Work Orders], [Sales Insights].[Essentials], [Sales Insights].[Sales - Internet] AS [Internet], [Sales Insights].[Sales - Voice] AS [Voice], Null AS [Mobile Orders] FROM [Sales Insights] UNION All SELECT [Mobile Sales].[Fiscal Month], [Mobile Sales].[Date], [Mobile Sales].[Center], [Mobile Sales].[Manager], [Mobile Sales].[Supervisor], [Mobile Sales].[Agent], [Mobile Sales].[PSID], [Mobile Sales].[MSO], Null AS [Calls], Null AS [Handle Time], Null AS [Talk Time], Null AS [After Call Work], Null AS [Hold], Null AS [Sales], Null AS [Gold], Null AS [Silver], Null AS [Choice], Null AS [Stream], Null AS [Video], Null AS [Bundle], Null AS [2 Play], Null AS [3 Play], Null AS [Work Orders], Null AS [Essentials], Null AS [Internet], Null AS [Voice], [Mobile Sales].[Mobile Orders] AS [Mobile Orders] FROM [Mobile Sales]; 

submitted by /u/mkelly1082
[link] [comments]

Microsoft Acess Developer Portland OR