11 Replies Latest reply on Nov 19, 2013 4:29 PM by alquimby

    look up gets strange results

    memanic

      Hello all!

       

      I once again have a problem and I'm reaoly grateful for this forum. Here's the problem:

       

      I have 2 tables with a match field of Item Name. The second table looks up Item Value from the first table. After a couple of week that part was working perfectly. Then I must have changed something while trying to populate the donations table. Now I get strange results: sometimes it works, sometimes not. And sometimes the looked up value doesn't show, but the calculation based on it does. I'm sure it's something simple, but can't for the life of me figure it out. Help please?

       

      Pat R.