title: Parameter values
body: <p>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:</p>
  
  <pre><code>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]) &amp; "-" &amp; "0" &amp; Month([BILLING_REJECTS_orig]![REPORT DATE]), Year([BILLING_REJECTS_orig]![REPORT DATE]) &amp; "-" &amp; 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]))
          );
  </code></pre>