title: I have been staring at this SQL code for hours and cannot see the problem probably just being dumb (Microsoft Access SQL)
body: <p>My code was working yesterday and I opened it up today and it now doesn't work. Maybe I accidentally added in an extra space. I have been through the code several times but cannot see the error. Another perspective would be very much appreciated.</p>
  
  <pre><code>SELECT [Student data].[Student First Name], [Student data].[Student Last Name], Guardian.[Guardian First Name], Guardian.[Guardian Last Name], Guardian.[Phone number], Form.[Form group], Medication.[Medication Name] 
  
  FROM Form, [Student data], Guardian, Medication, [Student + Guardian], [Student + Medication] 
  
  WHERE (Form.[Form group] = [Student data].[Form group]) AND ([Guardian].[Guardian ID] = [Student + Guardian].[Guardian ID]) AND ([Student data].[Student ID] = [Student + Guardian].[Student ID]) AND ([Medication].[Medication ID] = [Student + Medication].[Medication ID]) AND ([Student data].[Student ID] = [Student + Medication].[Student ID]) AND ([Student data].[Severity]= 'High') AND ([Student data].[Severity] = 'Moderate') AND ([Student data].[Severity]= 'Low');
  
  </code></pre>
  
  <p>Yesterday the table showed exactly how it was supposed to however today it will only show the names of the fields.</p>