cocatenate two type of query

  • Thread starter Thread starter shah firdaous via AccessMonster.com
  • Start date Start date
S

shah firdaous via AccessMonster.com

Hi!
im using vb6 and access 2002
i wanna concatenate 2 types of fields, that means, one field is Date, and
another one is string
date=datepicker.value
string=combo1.text
how is the query is look like to concatenate that 2 types.
thanx
shah
 
Hi,


You mean horizontally? use & as in

SELECT field1 & ", " & field2 FROM myTable


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top