"SELECT * FROM TABLE1 WHERE (((Ins.Sub)=(""CHILDREN'S""));"
Doubling the double quotes will leave a single double quote in the output.
This will allow for the apostrophe in the data. Your example had mismatched
quotes, double quote at the end, nothing to match it. I added one in front
of Select, but you may have one somewhere else that will match it. Also, is
Ins.Sub the name of a field in Table1? If so, I would recommend a change.
Having a period in the name when periods are used to separate table and
field names can cause you a problem; at the least, it is likely to cause
confusion.
