Table Titles

[LJ99]

Hi,

I am trying to ceate a report which will return the results from a query with the table name from which the data originally came from, the data has been combined in another query, from three seperate tables.

Does anyone know how to bring through table names in queries or by any other method.

Cheers.

[GaryG]

I'm not 100% clear what you want. If you want to see the column names in your
output including the source table, the syntax should include the fully qualified
name of the attributes, such as:

SELECT [File.Filename], [Name.ed_name] from File, Name where editor = ed_name

(in the ex. above, editor is a foreign key from the File table to the ed_name attribute in the Name table.)

I usually produce my reports with code, so I generate the titles, column names, and the like in the VBA module(s) used to produce the reports.

Cheers,
Gary