USER in ace reports

In an ace report I have two select statements joined by a UNION and the results going into a temp table. I would like to use a variable name for the temp table being used in order to avoid problems with other users attempting to use the same report. What I would like to do is use the user name as part of the temp table name. How can I get this accomplished??? -------------------- ***** JBT ***** ------------------ J. B. Taylor (jbtaylor@lanmail.rmc.com) Reynolds Metals Company Manufacturing Technology Laboratory 3326 East 2nd Street Muscle Shoals, AL 35661-1258 FAX: 205-386-9656 Voice: 205-386-9658 -------------------------------------------------------