Robbydobbs Posted April 8, 2003 Share Posted April 8, 2003 Is there a way to setup a field so that whenever data is put into the field and you have to do a search on this field that it is already setup to be (==)exact and nothing else but that number will come up? example: If the field is "customer #" and the number is "10" and I do a search on this field I only want the "10" to come up and not 101, 1001, 100 and so on. Link to comment Share on other sites More sharing options...
CobaltSky Posted April 8, 2003 Share Posted April 8, 2003 Hi, If your Customer# field is defined as a text field, then a search for 10 will find 10, 100, 101 etc. However if it is defined as a number field, a search for 10 will only find 10. Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 8, 2003 Share Posted April 8, 2003 keep a calc field TextToNum for any serial "text-number" field in your db, and search this field instead. Link to comment Share on other sites More sharing options...
Robbydobbs Posted April 8, 2003 Author Share Posted April 8, 2003 Thanks that works great. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7850 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now