I'd like to thank the Academy, my 7th grade guidance counselor who gave me my first opportunity to debug a program and my peers here at ProFox who voted for me to receive this award!
Thank you all so much! :) PS: Does this mean I can raise my rates now? Paul -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Ted Roche Sent: Friday, April 20, 2018 10:50 AM To: [email protected] Subject: Re: INSERT INTO...SELECT Issue - SOLVED!!! On Fri, Apr 20, 2018 at 11:00 AM, Paul H. Tarver <[email protected]> wrote: > > On a whim, I decided to add an alias to the table (ie: sheet) name and then > update the field names to the full bracketed column name notation > '[xs].[abc]' along with the table/sheet alias in the query and incredibly it > worked! I'd like to nominate you for the WAG Of The Week Award! Well done! Glad you've got it working. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
