Conditions in macros

  • Thread starter Thread starter ChrisW
  • Start date Start date
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
 
For compound conditions, use this kind of construct:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2000: Data Type Mismatch in query 2
CONDITION IN MACRO #2 2
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Conditional Formatting NOT WORKING 7
where condition 5
CONDITIONS IN MACRO 2
Conditional Formatting macro: simple, but doesn't work 6
issue with textbox in form 2

Back
Top