table name

[jozino01]

hi,
i have tables with different names, but the same structure. i have queries and reports based on those queries

(for example - SELECT DISTINCTROW Sum([f29_sp1].[V_SPC1DIA1]) AS [Sum Of V_SPC1DIA1], Sum([f29_sp1].[POLYGON_AR]) AS [Sum Of POLYGON_AR]
FROM f29_sp1
WHERE (((Left([L4_CLASS_I],3))>=931) AND ((Left([L4_CLASS_I],3))<=940));

i want to show the name of the table on a report so user would know the source for each report.

any idea how to place a table name on the report, please?

 

[luceze]

Do you set the record source for your report at time of printing?

Eric

 

[RoyVidar]

Using a textbox with the controlsource of
[tt]=[RecordSource][/tt]

will provide the name of the recordsource of the report (table or query name - or the complete sql for a sql string). This would perhaps be the easiest way, but require that your queries are named in such way that the table name is included.

Roy-Vidar

 

[dhookom]

I would question why you have multiple tables with the same structure rather than a single table with a field that describes its origin table. However, this is an &quot;Access Tables and Relationships&quot; forum question and I can only assume you understand and have good reason to do this.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[jozino01]

Thanks for your tips.

dhookom - there are 117 DBF files from where data needs to be extracted.