Two search in a base

I thought you wanted an x in Trés petite taille et Petite taille if there is an x in both Trés petite taille AND Petite taille. Is that not true?

Or do you want an x in Trés petite taille et Petite taille if there is an x in Trés petite taille OR Petite taille? If you want this then change your and to or.

Thanks Fred

I tried that but same result : no crosses displayed…

Remember that equal is case sensitive. From your screenshots it looks like you have "X" (capitol) in your data, but you are searching for "x" (lowercase) in your formula.

Thanks, but same issue with x in lower case…

I tried :

if 'Trés petite taille' = "x" then "x" end

It does not work either…

Ok now you have to investigate the data. 

1) what kind of field is Trés petite taille?

2) if you put a 1 in one of the records and switch the formula to look for 1 does it mark it properly?

Hi Fred,

Thanks

I tried 1 in "petite taille" and "trés petite taille"  : when I put it in "petite taille et trés petite taille" in the filter, 1 does not appear…

 "Trés petite taille" is a text field

Did you change the formula in petite taille et trés petite taille to look for 1?

if 'Trés petite taille' = 1 then 1 end

then you can filter petite taille et trés petite taille to filter for 1

Yes it works with 1 with 

if 'Trés petite taille' = 1 then 1 end

So is there an error in the code :

if 'Trés petite taille' = "x" and 'Petite taille' = "x" then "x" end ?

I have not seen any record with both Trés petite taille and Petite taille marked with an "x" so I don't think anything is wrong.

Can you confirm that you have records with x's in both fields?

Yes I already joined a screen shot that I join again where one can see crosses in "trés petite taille", the other one is lower and can't be in the shot.

Find a record that has both or just put an "x" in both fields and see what happens. 

It does not work either.

Is this what you are looking to have?

Yes exactly, John

What do you enter in the filter box ? X ?

The first screen shot is the result of the search X in the filter of "Petites tailles et Très petite taille" : there is not cross…

I have't put anything in the filter box. Before moving on to that test your code with an "x" in each of the fields and see if your formula gives an "x". See how I have tested my code in my third screenshot.

If you do not put anything in the filter box search area hox can you use the formula ?

Anyway here are screenshots showing that the "Petites taille" and "Très petites taille" works well.

The formula will give its result automatically and has nothing to do with the filter. You can, of course, filter the result if you so wish.

Ok. But as you can see there is nothing in the column-formula there is something wrong somewhere. 

But where ?