FrigidDigit
Board Regular
- Joined
- May 10, 2005
- Messages
- 203
Hi
I have a query in which I have created an expression as follows:
SMTValue: IIf([SMT]=2,"SMT")
I then wish to concatenate the contents of another field with the result of this expression. I am using:
NewRank: [Rank] & [SMTValue]
When I run the query, I am prompted for the SMTValue parameter. Can someone please point my mistake out to me?
Thanks!
FD
I have a query in which I have created an expression as follows:
SMTValue: IIf([SMT]=2,"SMT")
I then wish to concatenate the contents of another field with the result of this expression. I am using:
NewRank: [Rank] & [SMTValue]
When I run the query, I am prompted for the SMTValue parameter. Can someone please point my mistake out to me?
Thanks!
FD