i want to concatenate 2 fields for search the data, im using vb6, and access 2002.
i have to look for the two fields, 1 is date field(search between 2 dates)
and 2 is string field.
im using combobox for selecting certain item,and date picker to select date.
how can i concatenate two different type of fields and look for my filter data?
plz provide the eg, query string!.