Here is the SQL statement: SELECT [Commissions payable2 by salesperson query].[Order Master].[Order Number], [Commissions payable2 by salesperson query].[Order Date], [Commissions payable2 by salesperson query].[Company Name], [Commissions payable2 by salesperson query].[SalesPerson], [Commissions payable2 by salesperson query].[Delivery Date], [Commissions payable2 by salesperson query].[Commission Date], [Commissions payable2 by salesperson query].[Market], [Commissions payable2 by salesperson query].[Order Master].[Manager], [Commissions payable2 by salesperson query].[Paid], [Commissions payable2 by salesperson query].[Invoice], [Commissions payable2 by salesperson query].[IMEI], [Commissions payable2 by salesperson query].[Data], [Commissions payable2 by salesperson query].[Feature 2], [Commissions payable2 by salesperson query].[Feature 3], [Commissions payable2 by salesperson query].[Feature 4], [Commissions payable2 by salesperson query].[Comp Plan], [Commissions payable2 by salesperson query].[Rate Plan Description], [Commissions payable2 by salesperson query].[Value], [Commissions payable2 by salesperson query].[Carrier], [Commissions payable2 by salesperson query].[Level], [Comp Plan Table].[Compensation], [Comp Plan Table].[Count Value], [Comp Plan Table].[Qualify for Quota], [Comp Plan Table].[Quota Value], [Comp Plan Table].[F1 Comp], [Comp Plan Table].[F2 Comp], [Comp Plan Table].[F3 Comp], [Comp Plan Table].[F4 Comp], [Commissions payable2 by salesperson query].[Rate Plan Cost], [Commissions payable2 by salesperson query].[Rate Plan].[Rate Plan], IIf([comp plan table.level]<0,[comp plan table.Compensation]) AS cb, IIf([comp plan table.level]>0,[comp plan table.Compensation]) AS [sales comp], [Commissions payable2 by salesperson query].[Reserve]
FROM [Commissions payable2 by salesperson query] INNER JOIN [Comp Plan Table] ON ([Commissions payable2 by salesperson query].[Comp Plan]=[Comp Plan Table].[Comp Plan]) AND ([Commissions payable2 by salesperson query].[Level]=[Comp Plan Table].[Level])
WITH OWNERACCESS OPTION;
This is what happened. We changed our commission amounts, and I added a column to the Comp Plan Table so I could indicate the type of commission, example: Emp, Mgr, Agent-TIC, Agent-NIP etx. After I added this column, the report would not print. So I deleted the column. Now the query runs but does not show any data and the report has error where data should be.
I noticed when I run the query now an extra column appeared where the deleted column was but there is no field name.
Any thoughts on this?