Greetings! what is most efficient way to query a base for zip codes >= 12499 and <=14999 for example? Thanks
Solved
Searching a base which has a field zip code for example
Best answer by ScottWorld
Make sure that your zip code field is set to be a number field (instead of a text field).
Then, you can use the “Filter” button in the toolbar to create 2 filter criteria.
Filter #1:
Zip Code >= 12499
Filter #2:
AND Zip Code <=14999
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:
+35Make sure that your zip code field is set to be a number field (instead of a text field).
Then, you can use the “Filter” button in the toolbar to create 2 filter criteria.
Filter #1:
Zip Code >= 12499
Filter #2:
AND Zip Code <=14999
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:
Make sure that your zip code field is set to be a number field (instead of a text field).
Then, you can use the “Filter” button in the toolbar to create 2 filter criteria.
Filter #1:
Zip Code >= 12499
Filter #2:
AND Zip Code <=14999
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:
Thank you so much for your response. My zip code field is currently a single line text…can I change it to a number field as you suggest without losing data? I have 2652 records?
+35Thank you so much for your response. My zip code field is currently a single line text…can I change it to a number field as you suggest without losing data? I have 2652 records?
Yes, you can change it without losing data.
Yes, you can change it without losing data.
You are the best! Thank you so very much. I see solution is already checked!
+35Sorry…# integer or decimal?
Choose integer for the formatting.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.