Two search in a base

When you say "cross" are you typing in the letter "x"? Or is this an icon? What kind of fields are they (text, number, etc)?

Don't you then do a select like:

 

select Table1 where field1 = "x"  and field2 = "x"

Maybe you can tell me exactly what you are trying to do.

 

Your last formula doesn't need an end, if you are just doing a select.

I am trying to create a formula as you told me to do but I do not succeed !

 

select Table1 where field1 = "x" and field2 = "x"

Please tell us what do you want to happen?

 

what tables are you using? 

 

What fields are you using?

 

are you in a record or are you looking at a table view?

Hi

 

I am on a table called "Oiseaux famille genres espéces" (in the begining I made a mistake I put "Table ok*")

Among others I have 2 fields in a base.

-One with a cross inside sometimes (x)

-Another one also with a cross inside sometimes (x)

I am trying to create a formula to search and display the records with a field with a cross in one field called Trés petite taille and in the same time another one called Petite taille

 

I created a new formula field that I called  "Trés petite taille et Petite taille"

I entered in the formula area :

 

for in select 'Oiseaux famille genres espéces' where Trés petite taille = "x"  and Petite taille = "x"

 

I tried with for in and without "for in" in the beginning and with "end" and without end at the end

 

I alway have this error :

 

"Identifier waited on the line 1, column 6"

 

Coul you please help me ant telling me where is the error in my script ?

In your formula field "Trés petite taille et Petite taille" put this code

 

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

 

Regards John

Thanks John

no more error this time but it does not work.

I displayed the new field formula "petits et trés petits" : it is empty !

That is correct. It will only have an "x" in it if both Trés petite taille and Petite taille have an x in them and there are no records in your screenshot that have that. Are you sure that is what you wanted?

It looks like the formula is working. The records you show do not show "x" in both Trés petite taille and Petite taille so then there is nothing in petits et trés petits.

 

Look for records that have an "x" in Trés petite taille and Petite taille and then see what petits et trés petits displays.

Thank you

 

Strange...

 

I just noticed that my formula field "petites tailles et très petite taille" is in a text format in the table view !

I can't no more drag and drop it again because it is no more in the right window…"available columns"

I think it is the explanation of the issue : the column "petites tailles et très petite taille" in the table view is not a formula...

What could I do ?

I create a new formula field and the same thing happens : when I drag and drop the formula from the right window to the left one the formula becomes a text field !

By the way if the fied was a formula field what I have to enter in the filter area of the column ?

x ?

The picture from May 30 10:17pm doesn't change the formula field into a text field. What it is showing you is that the data in the field is text. The field is still a formula field. The Edit Columns window doesn't edit fields. Only the Edit Fields window does that.

 

You are correct, you just need to put x in the filter and it will show you all records with an x in that field.

Thanks Fred

When I enter a X in the filter no X are displayed…

 

You can't try ="x, but I suspect that you don't have any data that has an x in both fields. Can you find, or make, a record that does and see what the new field says?