Newbies archetypemusic Posted July 27, 2006 Newbies Posted July 27, 2006 I have a very simple find need but I can't seem to figure it out. We have a music data base and all that I want to do is find all songs that start with "a". Either "A Dark Night", "Another time" or "Abacrombie". When I do a find simply with a in the Title field I of course get every song that has an a anywhere in the title. If I do an =a find I get any title that has a single a within the title. Thanks for your help, Mitch
Newbies archetypemusic Posted July 27, 2006 Author Newbies Posted July 27, 2006 Thanks Tom for the quick response. I tried your suggestion but I get "No records found". Mitch
Newbies archetypemusic Posted July 28, 2006 Author Newbies Posted July 28, 2006 I tried the find again ==a* and I get "No Records Match This Request" Mitch
Fitch Posted July 28, 2006 Posted July 28, 2006 Oh... FileMaker 3, sorry I just noticed that. OK then, make a calculated field of type text: Left( Title, 1 ) and search on that.
Newbies archetypemusic Posted August 1, 2006 Author Newbies Posted August 1, 2006 Thanks Tom for your help. That did the trick.
Recommended Posts
This topic is 7025 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