Newbies Dale Parker Posted August 12, 2004 Newbies Posted August 12, 2004 I have a database that has a number field with numbers from 1 through 35. If I want to select the records with numbers 1, 5, 32, is there an easy way to do it....instead of multiple requests? Please help! Thanks....
QuinTech Posted August 12, 2004 Posted August 12, 2004 Not easy, no. Sorry. But the difficult way may be worth it for you. Why do you not want to enter multiple requests? Jerry
bruceR Posted August 12, 2004 Posted August 12, 2004 I wonder what he means by multiple requests. He might mean, enter find mode, find the "1" records. Enter find mode again. Find "5" records. Enter find mode again. Find "32" records. Dale, do you understand that you can create multple request before performing the find? Enter find mode, enter 1 in search field. New request; enter 5; new request; enter 32. Now perform find. Also, you could use a global field, a checkbox and a relaltionship to show all the records in a portal.
Lee Smith Posted August 12, 2004 Posted August 12, 2004 I'm wondering if there isn't something else these records have in common that the find could be based on, that would return these records 1, 5, and 32? Lee
Newbies dmi05 Posted September 24, 2004 Newbies Posted September 24, 2004 This is a little late (only here when I need help), but...if you want to find those exact numbers all of the time, why not another field (calculated field--If(yourfield=1 or yourfield =5 or yourfield=32, "x", ""). Then you could find on the new field (find new field=x) or create a script that will do it. Another way would be to make a "Dummy" find. Enter find mode (find 1), and without entering anything in any of the fields, control N for new request (find 2), control n for new request (find 3). Do this for as many finds as you'd like. Then create a script that would be to restore the find. When you perform the script you would be taken to find mode with three (or your number of finds) blank find request. You could then enter your numbers to find.
Recommended Posts
This topic is 7365 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