Error Message when Trying to filter a query

[SAFE Program]

I have a query on diffrent hospital information. I want to just view the provided information on just one specific hospital but it gives me this error message: SINTAX ERROR (MISSING OPERATOR) IN QUERY EXPRESSION 'HOSPITAL NAME'



This is the formula I have. [SELECT [SA Case Table].[Exam Date], [SA Case Table].[Case Type], [SA Case Table].[Patient Last Name], [SA Case Table].[Patient First Name], [SA Case Table].[Medical Record #], [SA Case Table].[Hospital Name], [SA Case Table].SANE
FROM [SA Case Table];]


If I try to pull the hospital name from the Hospital table I created I still get the same error message

Formula:
[SELECT [SA Case Table].[Exam Date], [SA Case Table].[Case Type], [SA Case Table].[Patient Last Name], [SA Case Table].[Patient First Name], [SA Case Table].[Medical Record #], [Hospital Lookup].[Hospital Name], [SA Case Table].SANE
FROM [Hospital Lookup] INNER JOIN [SA Case Table] ON [Hospital Lookup].[Hospital ID] = [SA Case Table].Hospital;]

[davegri]

And the error message is ????

[SAFE Program]

sintax error (missing operator) in query expression 'hospital name'

[isladogs]

I think the problem is end the end of the query. You have a superfluous ] after the ;

[Micron]

It begins with [ as well? Never seen that before.

[isladogs]

True. That should also be removed

[June7]

Remove spaces and special characters from names and brackets will not be needed.

That outer bracket pair is definitely odd. Why are you using that?

[moke123]

Just a word of caution if your database concerns what I think it may, besides Hippa concerns, there are often court imposed protective orders governing the information too.
Access is far from a secure platform.