title: What is my missing operator in my query expression?
body: <p>First off, I am very new with Access so apologies if this is super basic, but I am running into an issue with my query and I do not know what the problem is.
  Here is my code:</p>
  
  <pre><code>SELECT [Long Hours].[STORE NUM]
  FROM [Long Hours]
  ORDER BY [Long Hours].[STORE NUM];
  </code></pre>
  
  <p>The query runs properly, but when I try to sort the data I am given this error:</p>
  
  <blockquote>
    <p>Syntax error (missing operator) in query expresson 'STORE NUM'.</p>
  </blockquote>
  
  <p>I know this error is often caused by not bracketing fields that contain spaces, but my fields are bracketed, so I'm not sure what the issue is.</p>
  
  <p><a href="https://i.stack.imgur.com/MHvYM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MHvYM.png" alt="enter image description here"></a></p>