G
Guest
I am trying to use "Like" to return a record containing text in a box on a
form. This wasn't working, so I put the actual value in the query and that
wouldn't work either. I've tried changing the syntax so many times I'm not
sure what is right anymore.
SELECT records FROM records
WHERE (((records.SH)='%9010%'));
The SH field contains strings like "8070, 9010, t-240"
I've tried "%CSTR(Form![form]![text])%", "%" & CSTR(Form![form]![text]) &
"%", and several similar arrangements. If I had hair I would be pulling it
out.
Any help is greatly appreciated.
form. This wasn't working, so I put the actual value in the query and that
wouldn't work either. I've tried changing the syntax so many times I'm not
sure what is right anymore.
SELECT records FROM records
WHERE (((records.SH)='%9010%'));
The SH field contains strings like "8070, 9010, t-240"
I've tried "%CSTR(Form![form]![text])%", "%" & CSTR(Form![form]![text]) &
"%", and several similar arrangements. If I had hair I would be pulling it
out.
Any help is greatly appreciated.