How to add text to a query 1

[Bill4tektips]

I have a Report running off a query and dependent on the inputs on a Form I need it to add text. What I have in my query at the moment is
Select: IIf([Monthly Status]![SelectY/N]="Yes",[Monthly Status]![meeting number]+"Half",[Monthly Status]![meeting number])
What I am trying to achieve is when SelectY/N field is yes then it puts the word "Half" after the 'meeting number' field. All I am getting at the moment is #Error.

 

[PHV]

Replace + with &

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Bill4tektips]

I tried that before and it doesn't work. In previous queries where I've needed to put text between fields I have put & "text" &, but this is the first time I have wanted to put text at the end and that doesn't seem to work.

 

[HarleyQuinn]

Prefix all your control references with [forms]!

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

Just out of interest, what type of field is "SelectY/N"?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Bill4tektips]

It's a Yes/No field (Check Box)

 

[HarleyQuinn]

I had a feeling it might be, go with my previous advice, but change the [Monthly Status]![SelectY/N]="Yes" to

[forms]![Monthly Status]![SelectY/N]=True

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Bill4tektips]

Thanks HarleyQuinn! That got it

 

[HarleyQuinn]

Glad I could help, thanks for the star

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.