not less than and not greater than statement

[tsvetkovd]

Please, help me to figure out how my statement should look like. I need to make the following statement: waste not < 12 and not > 36. Thank you

 

[pbaldy]

Waste >= 12 And Waste <= 36

Or Between in SQL.

 

[tsvetkovd]

Thank you for responding. When I typed this in the access, builder said "invalid syntax"

 

[Drunkenneo]

U can use between 12 and 36 instead

 

[pbaldy]

It would work depending on where it was used. Try a validation rule of:

Between 12 And 36