[AccessD] Delete Table from report

Tim,

You miss the point, don't use a temp table unless absolutely needed.
Use queries instead to build up the data for the final select query that
is used at 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:37
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Delete Table from report

Actually it is a select statement, but that still has an open connection
to the table, so I can't delete the table.  I also tried to reset the
recordsource, but after the report opens, I can't change it.  Thanks.

Tim
-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Thursday, May 01, 2003 2:28 PM
To: accessd at databaseadvisors.com
Subject: RE: [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 
-----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