title: Using wildcard for Parameters with Joins, MS Access
body: <p>I have 2 databases where the entries should be equal, but unfortunately one database has some extra spaces in it.</p>
  
  <p>My b.ACCTNO parameter have proper records, an example like "AAA", but a.Account will have it as "_AAA" where the underscore is a space. </p>
  
  <p>I'm trying to use wildcards in my join statement to get it to match. No syntax issues but the wildcards don't seem to work at all.</p>
  
  <pre><code>From AR_Open_Query as a inner join GuAccount as b ON b.ACCTNO like ("*" &amp; a.Account)
  </code></pre>
  
  <p>The above code, I get less results then without a Join due to the spacing in records not matching with the non-spaced records.</p>
  
  <pre><code>ON b.ACCTNO = a.Account
  </code></pre>
  
  <p>If I do not use wildcards like this, I actually get slightly more results, but 
  not achieving what I'm looking for. </p>
  
  <p>Any suggestions? And thank you in advance. </p>