searson1 Posted September 13, 2006 Share Posted September 13, 2006 Hi, A real Newbie here. Hope you can help me. I have created a database which consists of names, dates, text boxes etc etc etc. What I would like to do is to create a query which would, for example, sort through the thousands of entries that I have and say list all the males who were 18 in 1986 (did that make sense?), then I would like that info displayed on the screen. Is it possible for me to create a script using a button to do this so the user can just press it and get the info? Am I able to do this, and if so, could someone kindly help me here. I do hope you can help. Mark Link to comment Share on other sites More sharing options...
Ender Posted September 14, 2006 Share Posted September 14, 2006 You can do something like this just by using the build-in Find operations. This can be scripted (and attached to a button) by doing something like: Enter Find Mode [] Set Field [ Gender ; "Male" ] Set Field [ Date of Birth ; "<=" & date(month(get(currentdate)); day(get(currentdate)); year(get(currentdate))-38) ] Perform Find [] Note that finding out who was 18 in 1986 is the same as finding who is (or would have been, for those since deceased) 38 this year. Your requirement: list all the males who were 18 in 1986 could be interpreted in a number of ways. I chose to interpret it to mean "18 or older as of this day in 1986". If you wanted to find those that had an 18th birthday sometime during the year or who were 18 at any time during the year, these are a little different, each requiring a range in the date part of that criteria. Link to comment Share on other sites More sharing options...
searson1 Posted September 14, 2006 Author Share Posted September 14, 2006 Hey, thank yo so much! A response that a Newbie understood. You are very kind indeed. Thanks for the reply and the info. Much appreciated. Mark Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6569 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