Syntax for condition between two values

How do you write a basic condition (e.g. whether to calculate a table) to achieve something like

0>[FieldX]<=6

?

Sorry, I keep doing this - its

[Total columns]>0 and [Total columns]<=5

right?

That’s correct.