Creating a column to hold data in Access SQL

[Lawless]

With T-SQL if you write something like: amount = 1 and amount is not a defined column in the table you are using to draw data from, it will make a column named "amount" and fill it with the value 1

In Jet-SQL with Microsoft Acces if you do this you get a pop up box that ask you to enter the parameter value for "amount".

Why and how can this be changed to get the same results that I get with T-SQL

[ADezii]

With T-SQL if you write something like: amount = 1 and amount is not a defined column in the table you are using to draw data from, it will make a column named "amount" and fill it with the value 1

In Jet-SQL with Microsoft Acces if you do this you get a pop up box that ask you to enter the parameter value for "amount".

Why and how can this be changed to get the same results that I get with T-SQL

I do not believe that this bahavior can be changed.