how to print a temp table

J

Janis

I have an Excel report output from Access. I need to change the fields in
the report. In the Excel macros you can't tell what the field definition
names are. There is a temporary table created from the make query reports
that I would like to look at the fields names. What I want to know is how do
I get access to the temporary table before it creates the report?

Here is the query:
if bEntireCompany = true Then
'sTempQry = "qryMake_Co_Signage"
sQryNm = Rpt_Co_Signage"
sEventDetail = tblTEMP_CO_EventDetaiol"
Else
xxxx
End If

the else part doesn't matter to me at this point because the report I am
dealing with has the entire company flag.

I just need a printed list of all the fields and the ID fields. I think it
may have what I want in this temporary table but I don't know where it is
stored or if it is deleted? In the report the names are changed to just the
field labels.
tnx,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top