Conditions in macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChrisW - 15 Mar 2007 13:39 GMT

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

Reply to this Message

Allen Browne - 15 Mar 2007 16:35 GMT

For compound conditions, use this kind of construct:

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Can anyone let me know why Access insists that conditions in macros
> don't seem to support comparitive operaters for checking ranges, and
[quoted text clipped - 3 lines]
> condition, but it did work when I changed it to (Forms![Form1]![Age]
> Between 20 And 25).

Reply to this Message