title: parameters on concatenated column Access
body: <p>I am new to Access but I did work with SQL before.</p>
  
  <p>I want to use Parameters to filter an query by a date. Unfortunately, there is no exact date but we have to work with text columns "year" and "week". I concatenate these columns so that lexicographic order equals datewise order. 
  The select statement works well. Especially I will get expected entries in the DISPO column
  However, when I add the parameter line and execute my query, I will be asked not only for values for BeginDate and EndDate but also for DateColumn. At the end the "where"-statement will not work as desired: It will use the entry from typed in for DISPO and not the entries received by the select statement.</p>
  
  <pre><code>PARAMETERS BeginDate Text ( 255 ), EndDate Text ( 255 );
  SELECT 
      MyDB.art_nr AS ArtNo,
      MyDB.dispo_jahr AS Year, 
      MyDB.dispo_kw AS Week, 
      (MyDB.dispo_jahr &amp; "-" &amp; MyDB.dispo_kw) AS DateColumn
  FROM 
      MyDB
  WHERE 
      (   DateColumn Between [BeginDate] And [EndDate]
      )
  ORDER BY MyDate
  </code></pre>
  
  <p>Can you help out and fix my parameter problem?</p>
  
  <p>Greetings,
  Peter</p>
  
  <p>Disclaimer: I reduced my query for this forum. the actual query is an inner join of multiple databases.</p>
  
  <p>Example output without the line of parameters:</p>
  
  <pre><code>Line1: ArtNo Year Week DateColumn 
  Line2: 1 2016 33 2016-33 
  Line3 2 2016 34 2016-34 
  and so on. 
  </code></pre>
  
  <p>I want to filter rather on 2016-33 than applying two filters on column Year and Week. The latter one is more complex especially if you want to have a chart with data from 2016-33 to 2017-15.</p>