Join 2 Fields

[dr223]

Hi,


I am working with Access 2003.

I have the following select statement;

SELECT QryCalcWPM.A.BusinessType, QryCalcWPM.B.BusinessType, QryCalcWPM.Score
FROM QryCalcWPM
ORDER BY QryCalcWPM.Score DESC;

Result

A.BusinessType B.BusinessType Score
A X 30
B Y 20
C Z 10

I want the ouput to be;

BusinessType Score
A/X 30
B/Y 20
C/Z 10

Note: '/' is just a symbol and not necessary a division.

Thanks

 

[pbaldy]

How about:

SELECT QryCalcWPM.A.BusinessType & "/" & QryCalcWPM.B.BusinessType AS BusinessTypeCombined, QryCalcWPM.Score