COlumn in query with table name

John liem

Registered User.
Local time
Today, 20:21
Joined
Jul 15, 2002
Messages
112
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.
 

Users who are viewing this thread

Back
Top Bottom