Insert statement w/ Wher wildcard "11163*"

[vlingen]

How do you write a SELECT statment when the WHERE has a wildcard in VBA?

Example:

INSERT INTO SFilterTable (ID, Field1, Field2)
SELECT Sale.ID, Sale.Field1, Sale.Field2
FROM Sale
Where Sale.Field1 = 11163*

Essentially what I have a a Find Form where the user can choose to include or exclude criteria for every field in the table. One request was to include all records where Field1 with 11163

The stament I wrote gets a syntax error.

Thanks!

 

[PHV]

Where Sale.Field1 Like '11163*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vlingen]

I tried that so my exact command looks like:

INSERT INTO SalentryFilter ( SALENTRYID, ADDRESS, UNIT, TOWN, SUB, DEED_DATE, SALE_AMT, CLASS, COMMENTS, [SIZE], BLDG_SQ_FT, BLDG_STYLE, PIN, AC_SF, ENTRY_DATE, YEAR_BUILT ) SELECT SALENTRY.SALENTRYID, SALENTRY.ADDRESS, SALENTRY.UNIT, SALENTRY.TOWN, SALENTRY.SUB, SALENTRY.DEED_DATE, SALENTRY.SALE_AMT, SALENTRY.CLASS, SALENTRY.COMMENTS, SALENTRY.SIZE, SALENTRY.BLDG_SQ_FT, SALENTRY.BLDG_STYLE, SALENTRY.PIN, SALENTRY.AC_SF, SALENTRY.ENTRY_DATE, SALENTRY.YEAR_BUILT FROM Salentry WHERE Salentry![Pin] Like 11163*

But I get a Syntax error (missing operator) in query expression 'Salentry![Pin] Like 11163*', occured in CmdFilter_Click


Thanks for the help.

 

[PHV]

Reread my post carefuly:
Where Sale.Field1 Like [!]'[/!]11163*[!]'[/!]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886