Curious thought and looking for options.
If you create a temp table in a Report|Action Example: SET ERROR MESSAGE 2038 OFF DROP TABLE tinstall PROJECT TEMPORARY tinstall FROM cust USING ALL WHERE install > (#DATE - 365) ORDER BY install DESC SET ERROR MESSAGE 2038 ON Where would YOU drop the tTable. If you do it in one of the actions, it seems you stop your ability to use the report designer (of course you can pre-create a temp table) but is there another way in actions that is short and sweet (less than 50 lines of code). I am now just dropping the table in the .eep that launched the report. Sincerely, Paul Dewey New Horizon Interlock Inc. New Horizon Safety Diagnostics Inc. www.interlockinfo.com Saving Lives - One Breath at A Time ™ This e-mail message is intended only for the named recipient(s) above and is covered by the Electronic Communications Privacy Act 18 U.S.C. Section 2510-2521. This e-mail is confidential and may contain information that is privileged or exempt from disclosure under applicable law. If you have received this message in error please immediately notify the sender by return e-mail and delete this e-mail message from your computer.
