How can I merge 2 fields ?

[rfear]

I want to turn this set of fields returned from a query :-

'Stage'-'Engineer'-'BDE'
A-a-e
A-b
B-c-f
C-d

Into this result by merging the fields 'Engineer' and 'BDE' :-

'Stage'-'NewField'
A-a
A-e
A-b
B-c
B-f
C-d

Something like [Engineer]&[BDE] just joins up the text which isn't what I want.
A-ae
A-b
B-cf
C-d

I hope this makes sense.

 

[tehNellie]

by merge you mean you want [Engineer] and [BDE] presented as a single [new column]?

You could use a union query:

SELECT [stage], [engineer] as newfield
FROM tablename
UNION ALL
SELECT [stage], [BDE] as newfield
from tablename

The ALL forces the query to display all values otherwise if both Eengineer and BDE contain the same value it will only be listed once.

 

[rfear]

Cool, thanks.