how do you write an expression in Microsoft access that is greater than or = to 5 but less than or = to 10?

Question

I would be using the expression builder, i am stuck on this one need a little help please.

Answer 1

fieldname>=5 and fieldname<=10

Answer 2

Ms Access Expression

Answer 3

x is under or equivalent to eight is x ? 8 x is larger than 5 ia x > 5 combine this mutually 5 < x ? 8 (think of the 5 < x for the period of this as in case you're analyzing from good to left, the < will become better than)

Answer 4

Place in your CONTROL SOURCE:



=IIF([fieldno]>=5 And [fieldno]<=10,"OK","NO")



I used the function here, IMMEDIATE IF, so that when the data on fieldno is between 5 and 10, it will say OK.





Good luck!

Answer 5

(Considering you're working on a query)



In the criteria line, in the column field you want to analyze, you write ">4" and "<11"

Answer 6

let ur field to be used in condition be rollno for instance." rollno>=5 and <=10.. "