-
Bring two fields from 2 tabels together, adding some text.
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...
-
Bring two fields from 2 tabels together, adding some text. (reply)
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|