I am new and without experience doing queries in Access. A friend advise me to join the wrong forum -Microsoft SQL, but I got fast help from a nice person. The problem is that now I have to convert this information into an IIF statement or maybe if someone has another idea...I will be very thankful.
My problem is that I need to do a query to show only the error in a sequence of numbers in two columns. The number from "RangeTo" has to be in the next row of the column to the left. If there is another number it is consider a "0".
Can someone be so kind and help me please.