Vba Sql Criteria Syntax

[tomtan29]

Could someone tell me what is wrong with this syntax?

SQL = "SELECT [TBL_CUSTOMER].* FROM [TBL_CUSTOMER] WHERE [Tbl_Cost_Code] LIKE """ & "*" & Param & "*"""

Or even This one

 SQL = "SELECT  * FROM TBL_CUSTOMER WHERE [TBL_CUSTOMER].Tbl_Cust_Name = " & "'" & "*" & Param & "*" & "'"

I ve tryed several syntaxes to make it work but nothing

I even tryed to complete the param Variable with * inside

Param = "*something*"
SQL = "SELECT  * FROM TBL_CUSTOMER WHERE [TBL_CUSTOMER].Tbl_Cust_Name = " & "'" & Param & "'"

This doesnt work either

SQL = "SELECT  * FROM TBL_CUSTOMER WHERE [TBL_CUSTOMER].Tbl_Cust_Name = '" & Param & "'"

Even This.

I am really frustrated i would Really apreciate any kind of help.

[MikeTheBike]

Hi

Got go out, but just one thought, as you don't give any information where or with what you are using the SQL or what is not working, but if you are usinig an ADO recordset (as apposed to DAO) then the wild card characture is a % NO an *.

HTH


MTB