[AccessD] Delete Table from report

Tim,
 
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.

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

-----Original Message-----
From: Swisher, Timothy B. [mailto:tswisher at GFNET.com] 
Sent: Thursday 2003 May 01 13:11
To: accessd at databaseadvisors.com
Subject: [AccessD] Delete Table from report




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.

Tim 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030501/18304414/attachment-0001.html>