title: Creating a Field in Table that calculates days from a certain date already entered Access QUERY
body: <p>Using Access Database</p>
  <p>I have a table called &quot;Pasture Management&quot; and i am trying to calculate and add a &quot;Days Empty&quot; column to the table. I already have a date column called &quot;Actual Move out Date&quot; and i want to know how many days the paddock has been empty since that move out date. I know that i need to use the DateDiff Code in a query using SQL, but not to sure how to write it correctly so that it calculates the days empty and adds that value into the table under the &quot;Days Empty&quot; Column.</p>
  <p>So if i have a Move out Date for stock in a paddock of 15/6/2021, i want Access to be able to calculate the number of days the paddock has been empty for when i run the report and then add this number into the &quot;Days Empty&quot; column in my &quot;Pasture Management&quot; Table.</p>