title: Query in Access (adding missing values)
body: <p>I've got two tables, <strong>Guides</strong> and <strong>Availability</strong>. <strong>Guides</strong> is a list of guides, and <strong>Availability</strong> is a list of dates for which information is known about a particular guide. For instance <em>03/03/14 - Guide 3 - Available</em> or <em>05/03/14 - Guide 1 - Busy</em>. If a guide's availability on a particular day isn't know yet, there isn't an entry in <strong>Availability</strong> at all for that day.</p>
  
  <p>I want to write a query that will return a list of the statuses of all the guides during the next three days. If the status isn't known it will say <em>Unknown</em>.</p>
  
  <p>I'm sure in SQL this task is definitely doable, but I am constrained by having to write a Web App in Access 2013. This means I must use the query editor in Access. Can anyone with expertise offer some guidance? If anything is unclear in the question, do say so.</p>
  
  <pre><code>Example query output:
  03/03/2013 - Guide 1 - Busy
  03/03/2013 - Guide 2 - Unknown
  03/03/2013 - Guide 3 - Unknown
  04/03/2013 - Guide 1 - Available
  04/03/2013 - Guide 2 - Available
  04/03/2013 - Guide 3 - Unknown
  05/03/2013 - Guide 1 - Unknown
  05/03/2013 - Guide 2 - Unknown
  05/03/2013 - Guide 3 - Unknown
  
  Table: Guides
  Guide 1
  Guide 2
  Guide 3
  
  Table: Availability
  03/03/2013 - Guide 1 - Busy
  04/03/2013 - Guide 1 - Available
  04/03/2013 - Guide 2 - Available
  </code></pre>
  
  <p><em>P.S.: Someone has suggested I might need to make a third table listing all the dates for the next 10 years. This wouldn't be a problem if it helps with a solution</em></p>