Re: Append Query Problem - Posting record only once

I tried your suggestion. I attempted to add it into the query, in a
private sub function, and a module. Nothing seems to work. When I
enter the text, it turns red and says there is a compile error. I am
not very experienced with SQL, so I may be missing some code or not
entering it in the correct place.