title: Adding a column to existing table in access without using any relationship
body: <p>I am working on a project in ACCESS 2010 that requires me to give a rank to 30000 products based on their sales. I have tried using a query to do the ranking and it takes a long time. (Please find codes at <a href="https://stackoverflow.com/questions/30848800/making-the-ranking-query-efficient">Making the ranking query efficient</a>) </p>
  
  <p>I figured out that instead, I can just sort the table based on the Sales column and add a field with numbers 1 to 30000.</p>
  
  <p>So is there a way to add such a column, i.e. a column without any relationship to the existing table. </p>