If statement in query

[Joy83]

Hi
I have a query that has a certain number
I want to creat a new column in the same query an expression:
If this number between 1 and 10 then put the value 1

 

[jdraw]

Better to show us the query. Even go to sql view, copy the code and paste.
Also a sample of before and after would help with communications.

 

[The_Doc_Man]

Note that TECHNICALLY, you cannot create or not create a field, you can only populate or not populate the field you created.

 

[Joy83]

Select fld1, fld2, fld3, IIf(fld3 Between 1 and 10, 1, Null) As CalcField From yourtable

This is helpful thanks