Conditions in macros

C

ChrisW

Can anyone let me know why Access insists that conditions in macros
don't seem to support comparitive operaters for checking ranges, and
only support the Between.. And operators? I had a whole set of
conditions where some were checking between a range of numbers (such
as Age). Where I had 20<=Forms![Form1]![Age]<25, it was ignoring the
condition, but it did work when I changed it to (Forms![Form1]![Age]
Between 20 And 25).

Cheers,
Chris
 
A

Allen Browne

For compound conditions, use this kind of construct:

([Forms]![Form1]![Age] >= 20) AND ([Forms]![Form1]![Age] <= 25)
 
Top