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!
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!