Expression Builder Q

[OxDavis]

I want a text box on my report to return the sum of persons who are between ages x and y. The code works perfectly if I want to return persons below or above a certain age, but does not want to return persons within an age range.

Here is the code that is not working:

=Sum(IIf([Age]>=5<=9,1,0))

I have tried using

>=5 AND <=9

but to no avail.

Can anyone solve my noobish expression builder question?

 

[Ryko]

what about BETWEEN 5 AND 9?

 

[OxDavis]

Oops! Thanks for the tip!