In a field say FR1 I want to find the results of the 2nd and 4th FR1 numbers. I put 2and4 in my criteria and I get error message. What am I doing wrong. Thanks ed
Rick
27th February 2004, 05:21.40 PM
Because you are asking for everything that is equal to both 2 and 4.
You need to use 2 OR 4. That way if its equal to either 2 or 4 you will get it.