LIke

[Mark Richardson]

I am currently trying to create a query where I can search a string of numbers and indentify all records contain a specific number. I can do this using the Like "*2" but rather than having to change the number i am searching for everytime, i want to enable the user to input there desired search criteria.
Here is what i have written:

SELECT ['548 Deliverables Spreadsheet$'].*, ['548 Deliverables Spreadsheet$'].Comments
FROM ['548 Deliverables Spreadsheet$']
WHERE (((['548 Deliverables Spreadsheet$'].Comments) Like "*"=[Please enter error code:]));


Each part works on its own but won't together, can anyone give me any help. Am i going about this the wrong way. Should i be using an dynamic array to seperate the numbers up. I am not to clue'd in on arrays. Anyone know of any sites that offer info on setting them up.

Cheers
Mark

 

[neileg]

WHERE (((['548 Deliverables Spreadsheet$'].Comments) Like "*"&[Please enter error code:]));

 

[Mark Richardson]

TA Muchly,