Alias "table: " in a query (I do not understand!)

[Dennis]

Access 2000 & 2003

Must modify an inherited database with current data.

Within that .mdb file is a query object where I noticed in
standard Access the query layout, next to "Table: " a
reference to "Net Average Table" (example name)also
(quotation marks inserted for this discussion)

I cannot locate a "Net Average Table" in the Tables
Objects window.

Looking at the General Tab of the Fields List Properties,
for the "Net Average" Table, I see a reference to ->
Alias .................. "Net Average"

Looking into the Modules and the Macros Objects, there are
routines but, there is no reference to "Net Average." As
if a macro could have created an Alias file.

In help, a reference is made about an SQL statement may
create an Alias.

Guess, I am at a new level of Access that I have enough of
a clue to know that this is over my head currently. I am
lost.

How can I locate and analyze what makes-up this table? It
has fields that come from known tables and some fields
that come from ???

TIA Dennis

 

[Dirk Goldgar]

Access 2000 & 2003

Must modify an inherited database with current data.

Within that .mdb file is a query object where I noticed in
standard Access the query layout, next to "Table: " a
reference to "Net Average Table" (example name)also
(quotation marks inserted for this discussion)

I cannot locate a "Net Average Table" in the Tables
Objects window.

Looking at the General Tab of the Fields List Properties,
for the "Net Average" Table, I see a reference to ->
Alias .................. "Net Average"

Looking into the Modules and the Macros Objects, there are
routines but, there is no reference to "Net Average." As
if a macro could have created an Alias file.

In help, a reference is made about an SQL statement may
create an Alias.

Guess, I am at a new level of Access that I have enough of
a clue to know that this is over my head currently. I am
lost.

How can I locate and analyze what makes-up this table? It
has fields that come from known tables and some fields
that come from ???

TIA Dennis

You can see the "true" table name by looking at the query in SQL view --
look for " ... FROM SomeTableName AS AliasName ...". Or upi can open
the query in design view, right-click on the table's field list in the
top pane of the design window, and select Properties... The property
sheet will show you the Alias and the Source table name.