<div>
so if i had 6 fields &nbsp;a.wwgsku, a.WWGMfrNumCondensed, CompSKUCondensed,CompMfrNu<wbr />mCondensed<wbr />, item, Namert<br />
<br />
any brackets or parentheses ?
</div>


so if i had 6 fields  a.wwgsku, a.WWGMfrNumCondensed, CompSKUCondensed,CompMfrNumCondensed, item, Namert

any brackets or parentheses ?

<div>
You can include the column names in square brackets, if you wish. That way it is guaranteed that the name will not be rejected if it happen to be the same as one of the <a href="http://office.microsoft.com/en-au/access-help/access-2007-reserved-words-and-symbols-HA010030643.aspx#_Toc272229040" rel="ugc">reserved Access keywords</a>
</div>


You can include the column names in square brackets, if you wish. That way it is guaranteed that the name will not be rejected if it happen to be the same as one of the reserved Access keywords [http://office.microsoft.com/en-au/access-help/access-2007-reserved-words-and-symbols-HA010030643.aspx#_Toc272229040]

<div>
<div class="content wysiwyg-content">
ACCESS 2010<br />
<br />
i HAVE THIS CODE FROM SQL SERVER 2008<br />
<br />
Can this be used and translated to access sql &nbsp;??<br />
<br />
<br />
<br />

<pre><code id="code-10-28243701-1">ELECT distinct case when wwgsku = '44055' then 'WSKU'
      when WWGMfrNumCondensed = '44055' then 'WMFR'
      when [CompSKUCondensed] = '44055' then 'CSKU'
      when [CompMfrNumCondensed] = '44055' then 'CMFR' else 'NA' end as Match_Type
      , a.*
    
       
  FROM [XRef_Master_TD].[dbo].[main_xref_t1_1] as a
  where [CompMfrNumCondensed] = '44055'
  or [CompSKUCondensed] = '44055'
  or wwgsku = '44055'
  or WWGMfrNumCondensed = '44055'</code></pre>
<br />
<br />
<br />
Thanks<br />
fordraiders
</div>
</div>


ACCESS 2010

i HAVE THIS CODE FROM SQL SERVER 2008

Can this be used and translated to access sql  ??



(CODE)



Thanks
fordraiders

QUERY FROM SQL SERVER TO ACCESS

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.