COlumn in query with table name (1 Viewer)

[John liem]

How can I create a column in a query that reflects automatically the table name? Example: Table_ABC. has fields: ID, Material, Qty. I want to create automatically a column/field in the Qy_ABC with "ID", "Material" and "QTY", and in additon into it, next to "Qty" a filed/column is called "Name" and filled with "ABC". Thanks.

 

[Pat Hartman]

Select ID, Material, QTY, "ABC" As TableName
From Table_ABC;

"Name" is a poor choice as a column name since it is also the name of a property and will cause problems if you ever need to use the query in VBA. Also, ID is a poor choice as a key name. Common practice is to use the table name in conjunction with ID. Such as CustomerID, ProductID, ClassID, etc.

 

[John liem]

Pat, Thanks for your suggestions and solution.