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...