var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: combine 2 colums into 1
I have an Access 2000 DB with 2 colums, one called cabinet, another called drawer. I need to combine the information in these 2 columns into 1 called cabinet-drawer. Is there an easy way to do this?
It looks like this( 2 seperate columns) Cabinet Drawer
My desired results are
Thanks for the help
Last edited by idlewild70; 04-19-06 at 09:41.
You know what Jeff - there is
Concatenation - that's what you need:
SELECT cabinet, drawer, cabinet & drawer AS [cabinet-drawer]
ur codings are working excelent.
Thank you very much. Worked great