Hi!,
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!.
shah
Comments
: Hi!,
: 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!.
: shah
:
:
I think you can write something like this:
[code]
Dim QueryString As String
QueryString="Select * FROM YourTable WHERE YourField='Something' AND DateField=#YourDate#"
[/code]
After you have the QueryString,just use it as RecordSource of your ADO control,and it should return the filtered results.
Hope this helps!