Writing Formula in query on existing fields

[Esmatullaharifi]

I have a table linked to SQL Server 2014. As SQL Server 2014 does not support calculated fields I created a query to use formulas. Now I want to write formulas on the existing fields ( TotalMarks ) of table Not to create new fields. I tried but I can't. Please Help Me.

[ranman256]

A calculated field IS a "new field". Its a virtual field and does not exist except in the query. You WANT it to show as a new field.
In a query, in a blank column (field), type: =5+1 ,enter
a label will appear : Expr1: 5+1
change the label to your 'field name'. Change the function to what you want with fields..like TotalMarks: [Qty]*[Amt]+1

There is your functon.