Bring two fields from 2 tabels together, adding some text.

[Steve]

I have 2 tables Period and Week and what I would like to do is bring the fields together in a query, but with a little text of my choice in between the two figures.

The Two Fields are Period No and Week No, what Im after is an output like this:

P:[Period No],W:[Week No]

so when I run the query I get


P1 W1

Any help would be great...

[Bob]

SELECT 'P' + Period_No, 'W' + Week_No
FROM table1, table2
WHERE table1.key = table2.key


------------
Steve at 10/30/01 4:08:11 PM

I have 2 tables Period and Week and what I would like to do is bring the fields together in a query, but with a little text of my choice in between the two figures.

The Two Fields are Period No and Week No, what Im after is an output like this:

P:[Period No],W:[Week No]

so when I run the query I get


P1 W1

Any help would be great...