Specified field could refer to more than one table error message

[Nik]

This is the error message I am recieving: "The Specified field
'[Posters-2000].State' could refer to more than one table listed in the
FROM clause of your SQL statement."

I have looked in the sql code and could not find anything wrong, below
is the code:

SELECT [Posters-2000].[Document Number], [Posters-2000].[Needs Update],
[Posters-2000].[Last Update], [Posters-2000].[New Update Date], [Orders
Table].[Poster(s) Ordered], [Orders Table].[Order Type], [Orders
Table].[State Ordered], [Locations Table].Company, [Orders
Table].[Order Date], [Posters-2000].Title, [Locations Table].City,
[Locations Table].State, [Orders Table].[Quantity Ordered], [Locations
Table].Service, [Locations Table].[Location ID], [Locations
Table].Division, [Locations Table].Location, [Locations Table].[Contact
First Name], [Locations Table].[Contact Last Name],
[Posters-2000].State
FROM [Posters-2000] INNER JOIN ([qry Poster Offerings] INNER JOIN
([Orders Table] INNER JOIN [Locations Table] ON [Orders
Table].[Location ID] = [Locations Table].[Location ID]) ON [qry Poster
Offerings].[Poster Set] = [Orders Table].[Poster(s) Ordered]) ON
[Posters-2000].State = [Orders Table].[State Ordered]
WHERE ((([Posters-2000].[Needs Update])=Yes) AND (([Orders
Table].[Order Type])="New") AND (([Locations Table].Service) Is Not
Null));

It appears that everything has a table associated to it, if needed.
Maybe I just have been staring at it for way to long to notice anything.

 

[Guest]

I do not know but two things come to mind --
Try putting brackets around State where [Posters-2000].State appears (twice).

Is [Posters-2000] a table or possibly another query that might be the error.

 

[Nik]

I put the brackets in and it didnt work. And Posters-2000 is a table.