<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=888262418-01052003><FONT color=#0000ff
size=2>Tim,</FONT></SPAN></DIV>
<DIV><SPAN class=888262418-01052003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=888262418-01052003><FONT color=#0000ff size=2>Instead of the
temp table, why not use a query? Probably everything you did to get the
data into the temp table can also be done to create a select query to use as the
datasource for the report.</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Swisher, Timothy B.
[mailto:tswisher@GFNET.com] <BR><B>Sent:</B> Thursday 2003 May 01
13:11<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Delete Table from report<BR><BR></FONT></DIV><BR>
<P><FONT face=Arial size=2>Hi group, I have a report that on open builds a temp
table, populates the table, then displays the info in the report. I would
like to delete the table when the report closes, but since the report is bound
to the table, it will not let me delete the table. This is a standalone
report, it is not being called from a form or anything so I can't put the code
there. I open the report from the db window, do the processing, then I
want to delete the table. A2K by the way. Any ideas?
TIA.</FONT></P>
<P><FONT face=Arial size=2>Tim</FONT> </P></BODY></HTML>