Missing Operator error in the following code-I don't see what's miss'n 1

[Johnnycat1]

This is the line that keeps returning the error but for the life of me, I can't see what is missing.

concatenate("SELECT [Fixture Type] FROM[TblFixtureDetailing] WHERE [Lamp Type]=" & [TblFixtureDetailingLampTypes].[Lamp Type])

The error returns
"Syntax Error (Missing Operator) in Expression '[Lamp Type]=100A'.

100A is the Lamp Type from TblFixtureDetailingLampTypes.

Any Suggestions???

 

[Remou]

Looks like Lamp Type is text, so you need single quotes:
[tt]... [Lamp Type]='" & [TblFixtureDetailingLampTypes].[Lamp Type] & "'")[/tt]

 

[Johnnycat1]

Remou,

That is it. I forgot that I had copied this from another query that was based on an integer.

Thank You!