> Well, it is puzzling. If I change the third field to a numeric type, it > works. If the third field is a character type, it doesn't. > > I create a fresh table and it doesn't work. What can be the reason. > > My table is 'test' with fields ( test1 c(5), test2 c(1), test3 c(5) ). It > just doesn't work unless I change test3 to numeric type. > > Does it mean it only works in numeric type? > The results I got with the FPW2.6a Query Designer were with your initial data where no numeric fields were involved. It worked. Now, you're showing me yet another table that doesn't work for you. What happened to the first table called "Size" that you had defined? Did that work?