Searching two numbers
Hi
I'd like to find two numbers in a base :
8 and 10
I tried :
=8 and =10
Don't work !
Someone have any idea ?
Thanks
4 replies
-
I am unsure what you mean by base?
Are you trying to find records in your view that have either 8 or 10 in a number field?
or
Are you saying that you have a record that has a field that has multiple numbers in it? Now you want to find records that have the number 8 and the number 10 in that set of numbers?
-
Hi Fred,
"Are you trying to find records in your view that have either 8 or 10 in a number field?"
That is my question.
Some of my records have 6, some 8, some 10, some 12 as number in a field called "number"
-
Ok, if your field only has one number in it and you are in a table view that you now want to filter only the 8's and 10's then you need to use an "or" not an "and".
=8 or =10
if you do an "and" then it is looking for records that have both 8 or 10 in the field. since each record only has one number in the field you will not find any record that matches.
Hope this helps.
-
Ok. Thank you very much Fred.
Content aside
- 3 yrs agoLast active
- 4Replies
- 329Views