Joe
|
| Posted: 07/07/2004, 8:38 AM |
|
I am trying to complete the Search Form with a Multi-Select Listbox Tutrial. and i am having some trouble whne it gets down the theQuote :Open the 'Data Source' window by clicking on the [...] button next to the Data Source property of the grid form, then select 'SQL' in the "Data Source Type" field.
Add the 's_project' URL parameter to the grid's data source with "0" as a Default Value.
Then modify the SQL statement in the Data Source property by adding the "IN" statement as shown in the example.
I have tried and tried but nothing, any help would be great, This is what i have so far:SELECT *
FROM ProDetail
WHERE Customer_Name = '{s_Customer_Name}'
AND Pro_Number = '{Pro_Number}'
AND Pcs = '{Pcs}'
Where do i put the IN statement. I want to be-able to search multi customers, (Customer_Name)
I am using .asp, CCS, MS Access,
Thanks
|
