title: Access - Linked Excel Sheet query
body: <p>I am currently working on a database which will bring a number of excel sheets together. I have created a link between the ones in which I need and set up relationships in Access.</p>
  
  <p>I have first-year degree experience of Microsoft software packages. I am not going to move from Excel to Access as other team members are more comfortable using it. However running things like reports, creating forms and querying data can be easier in Access.</p>
  
  <p><strong>The Problem:</strong></p>
  
  <p>I am trying to query data from a linked spreadsheet and it sometimes works and sometimes doesn't. Often more than none my queries return blank when I know they shouldn't.</p>
  
  <p>Is this something to do with the table being linked and not an access table?</p>
  
  <p>Please see an example query that I have set up</p>
  
  <p><img src="https://i.stack.imgur.com/3vquv.png" alt="enter image description here"></p>
  
  <p>Thank you in advance.</p>