SELECT statement combining field data with text string

[fboehlandt]

Hi everyone,
I have the following SELECT statement below:

SELECT Performance.ID As Code

The entries for the Field 'Code' look something like this:

6473
4596
304
21
340

In the query I would like this to be changed to:

6473 mutual
4596 mutual
304 mutual
21 mutual
340 mutual

What changes do I have to make to the SELECT statement. Thanks in advance

 

[JamesMcS]

Change it to

Select Performance.ID & " mutual" AS Code

 

[fboehlandt]

Thanks for the quick reply

 

[JamesMcS]

No problemos, have a good one!