I am attempting to write a querie that will display in a drop down dialogue box in VB that will show the invoice number and the date of the invoice together. I thought that this would work:
SELECT (inv_no + ' - ' + date) as billinfo from billing.
I get the error Operand type clash: date is incompatible with int
inv_no is an int field in the db and date is a date field.
Anone have any ideas as to how to do this?