Parameter values

0

can anyone tell me why the following query is asking me for parameter values. It should be (or at least I want to) populating the table with data ‘from’ where it’s pulling it from:

SELECT [BILLING_REJECTS_orig].[ORG NBR] AS BK, [BILLING_REJECTS_orig].[ACCOUNT NUMBER] AS ACCT, [BILLING_REJECTS_orig].APPL AS AP, [BILLING_REJECTS_orig].[ACCOUNT NAME] AS [ACCT NAME], [BILLING_REJECTS_orig].[TMO NAME], IIf(Len(DatePart(“m”,[BILLING_REJECTS_orig]![REPORT DATE]))=1,Year([BILLING_REJECTS_orig]![REPORT DATE]) & “-” & “0” & Month([BILLING_REJECTS_orig]![REPORT DATE]),Year([BILLING_REJECTS_orig]![REPORT DATE]) & “-” & Month([BILLING_REJECTS_orig]![REPORT DATE])) AS [ACTIVITY MONTH] INTO Billing_Rejects_Orig
FROM dbo_BILLING_REJECTS_DEPT, TM_Report_Date
WHERE (((Year([Billing_Rejects_Orig]![REPORT DATE]))=Year([TM_Report_Date]![Report_Date])) AND ((Month([Billing_Rejects_Orig]![REPORT DATE]))=Month([TM_Report_Date]![Report_Date])));

Link: Parameter values
Source: Stack Sql

Share.

About Author

Leave A Reply