Adding () into SELECT query. help

[wadey]

1 table, 2 fields. 1 row.

In SQL Server the following statement in VB produces this result:-

Query - "SELECT [Field1] + '(' + [Field2] + ')' as FieldConcat FROM table1"

Result - FieldConcat = FieldRec1(FieldRec2)

Whats the MS Access version of this please ?

Regards

 

[smedvid]

lcQuery =
"SELECT [Field1] & '(' & [Field2] & ')' as FieldConcat FROM table1 "

should work... hthw,


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...