SQL code keeps asking for Parameter Value

[rplohocky]

I am trying to create a query from 3 other sources (3 tables). All 3 tables have the same structure and fields. I found this code online to do just that. The issue is when I run the code I have a window that pops up asking for Parameter value for [Curtis C Code],[Hotel Name],[Hotel Brand]. When I click OK on all the 3 pop ups the query is created with all 4 labels across the top and all the Hotel Codes are brought in to the query but none of the data from the other fields.

Can anyone tell me why this doesn't bring in all the data from all of these fields?

<code>select [Hotel Code],[Curtis C Code],[Hotel Name],[Hotel Brand]
FROM [G3 RMS Tracking]
union
select [Hotel Code],[ Curtis C Code],[ Hotel Name],[ Hotel Brand]
FROM [G3 RMS NOT Ready Tracking]
union
select [Hotel Code],[ Curtis C Code],[ Hotel Name],[ Hotel Brand]
FROM [tbl Achived Completed Hotels];
<code/>

 

[james_lankford]

many times you do
[ Curtis C Code]

you're not allowed to have spaces after the [

 

[welshgasman]

Don't have spaces in field names either. It just cause you grief like this.
If you want decent headings use can use this method

SELECT [forename] & " " & [Surname] AS [Full Name]
FROM tblEmployee;

which in design mode is

Full Name: [forename] & " " & [Surname]