How are you performing the search are you using for instance
01/01/1970 ... 01/01/1980 or are you doing it on the age field such as
20...30 (which should include all ages between such as 22, 25, 28)
Enter Find mode and type this into the Age field:
A more efficient way (assuming your Age field is an unstored calculation) would be to search the DOB field for dates between 30 years ago and 20 years ago.
Thank you for your Question it gave me the answer. I was not searching like 20...30. I did not know i could search like that, but I would like to have a button that is clicked and it asks what age range would you like to search? or something similer to that. Thank you
You have a few options.
If the age ranges are specific, place buttons for each range [0-16] [17-21] [22-30] etc
Add the range as a script parameter to the button, i.e "0..16"
Make a script which then performs the search, using get(ScriptParameter)
Or, you could add two global fields for start / end either allow entry into these fields with a button to search
or display a custom dialog box, using these fields
The script would then combine the fields as the basis of the search
g_age_start &"..."& g_age_end
SW and comment, thank you both for your help!!