Conditions

[Guest]

I am trying to Run a setvalue macro based on conditions the condition is if a number field is between certain numbers I am tjinking I am doing it right ex:
Report![Name]![Field] between 1 and 10
However not working

 

[tina]

try
Reports![Name]![Field] between 1 and 10

if that doesn't work, try
Reports![Name]![Field] >= 1 And Reports![Name]![Field] <= 10

hth

I am trying to Run a setvalue macro based on conditions the condition is

if a number field is between certain numbers I am tjinking I am doing it
right ex:

Report![Name]![Field] between 1 and 10
However not working