I'll need to put SQL commands in a field in front of every record (so that this can be put into another table) like:
Which is a change on the solution by dalchri on thread701-291171.
However, I don't know how to escape out in Access so that I can use SQL statements (and single quotes) within a field. Everytime, access just chokes on it. I tried Chr$(#) for some things, but that doesn't seem to work either. I know this is probably obvious, but I can't remember what you call it to do a search for it on Access' help.
Thanks a bunch,
=Daniel
Code:
SELECT 'imagio' As TEST, CL.LMFProjectID, Event, B
FROM (...Which is a change on the solution by dalchri on thread701-291171.
However, I don't know how to escape out in Access so that I can use SQL statements (and single quotes) within a field. Everytime, access just chokes on it. I tried Chr$(#) for some things, but that doesn't seem to work either. I know this is probably obvious, but I can't remember what you call it to do a search for it on Access' help.
Thanks a bunch,
=Daniel