B
Bigmike
I have a query called [AGECALC] that calculates the age of all entries in
table [MEMBERS]. It does this correctly using the common datediff formula
that everyone uses to calculate age.
I have a query [AGES BETWEEN] that searches for entries in query [AGECALC]
between a certain age range.
I have the following as the criteria for AGE
Between [Enter Minimum Age:] And [Enter Maximum Age:]
This query, if I enter the values 0 and 50 or 1 and 50, it returns everyone
between those ranges plus everyone 100 years old and above.
This doesn't happen if I search for "between 2 and 50"
Furthermore, if I enter the values 50 and 100, it asks me again to enter
both [Enter Minimum Age:] and [Enter Maximum Age:]. If I enter the same
values, it returns everyone between those values, plus everyone over 100.
Any ideas?? I have gone through so many posts in both this forum and
others. Believe me, I wouldn't ask the question otherwise. I really
appreciate any ideas that are offered! Thanks!
table [MEMBERS]. It does this correctly using the common datediff formula
that everyone uses to calculate age.
I have a query [AGES BETWEEN] that searches for entries in query [AGECALC]
between a certain age range.
I have the following as the criteria for AGE
Between [Enter Minimum Age:] And [Enter Maximum Age:]
This query, if I enter the values 0 and 50 or 1 and 50, it returns everyone
between those ranges plus everyone 100 years old and above.
This doesn't happen if I search for "between 2 and 50"
Furthermore, if I enter the values 50 and 100, it asks me again to enter
both [Enter Minimum Age:] and [Enter Maximum Age:]. If I enter the same
values, it returns everyone between those values, plus everyone over 100.
Any ideas?? I have gone through so many posts in both this forum and
others. Believe me, I wouldn't ask the question otherwise. I really
appreciate any ideas that are offered! Thanks!